yes there is an issue - of a confusing name. Use the cf_sql_timestamp,
which is the one that actually corresponds to datetime and smalldatetime.
Mark
Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD 20708-4038
Ph: 301-497-5596 Email: [EMAIL PROTECTED]
I am using CF 4.0 with MS SQL Server 7.0
Is there an issue with using cfsqltype="CF_SQL_DATE" in a stored
procedure?
I get the following error code while using a stored procedure
--------------------------------------------------------------
ODBC Error Code = S1C00 (Driver not capable)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
--------------------------------------------------------------
I have isolated the problem to the following code
<cfprocparam type="In"
cfsqltype="CF_SQL_DATE"
dbvarname="@StartDate"
value="#StartDate#">
<cfprocparam type="In"
cfsqltype="CF_SQL_DATE"
dbvarname="@EndDate"
value="#EndDate#">
I have used the regular <cfquery> tag to do the same query with no problem.
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists