Are StartDate and EndDate ODBC date objects?
If not, it may be that you're telling SQL server to expect ODBC dates, but
you're not them. (Whereas in your CFQUERY, SQL server is figuring out how
to handle that date data.)
What happens if you use value="#createODBCDate(createDate( <month,day and
year from startdate>))#"?
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 10:52 AM
To: CF-Talk
Subject: "CF_SQL_DATE"
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
