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