> 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/
