I have been banging my head against the wall all afternoon. I am trying to update a table in SQL 2000 with a date time column using a stored procedure. The procedure is set to recieve the variable as a Datetime format for SQL, I am sending it as a CF_SQL_Date type and have used about as many combinations of creating the date that I can think of... CreateDate - CreateDateTime - CreateODBCDate -CreateODBCDatetime
They all give me the same error that a variable of type varchar cannot be converted to datetime - in the stored procedure. So the variable itself is what? a varchar??? even though it should be a datetime... I have done some googling, but to no avail... If anyone can shed some light for me, that would be great! Thanks, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
