Rod: this seems to be a relavent post on this issue (see accepted answer) http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20670795.htm l
although I'm curious, is your circumstances the same, ie: your date isn't a FULL date? cheers barry.b -----Original Message----- From: Rod Higgins [mailto:[EMAIL PROTECTED] Sent: Friday, 11 July 2003 6:40 PM To: CFAussie Mailing List Subject: [cfaussie] RE: SQL Server ODBC error > No. It's strange, I have about 25 sp's in this database and every one of > them returns this error when called via a cf template?? Yet they all work > fine when called via iSQL?? Found the problem. SQL server requires date/time fields to be cf_sql_timestamp not cf_sql_date. Seems Sybase and SQL server differ in more ways then one. The problem code was in the sp call -: Old code snippet that woked when connected to a Sybase datasource; <cfprocparam type="in" [EMAIL PROTECTED] cfsqltype=cf_sql_date value="#CreateODBCDateTime(end_date)#"> Changed code snippet that works connected to a SQL 2000 datasource <cfprocparam type="in" [EMAIL PROTECTED] cfsqltype=cf_sql_timestamp value="#CreateODBCDateTime(end_date)#"> Sorry to waste ppls time, Rod --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
