I tried using ODBC date object and got the same error message. After doing
some search on the allaire forum I read that others were also having
problems. The suggestion was to use cf_sql_timestamp and it worked just fine
with that.
Thanks for your input.
Sebastian
on 12/7/00 2:41 PM, Hayes, David at [EMAIL PROTECTED] wrote:
> 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
