I use CF_SQL_TIMESTAMP as my cfsqltype. Then I can pass in the date like "08/20/2007" and it works fine.
Perhaps the parameter to your stored proc is defined as a varchar? Or, maybe your cfprocparams do not line up with the parameters of your stored proc and the wrong data is being passed into the wrong parameter. Depending on your updater version, dbvarname is generally ignored, and the order of the parameters is what is used. ~Brad -----Original Message----- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, August 20, 2007 4:38 PM To: CF-Talk Subject: Formatting a Date for MSSQL 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
