Hmm. Try using CF_SQL_TIMESTAMP. I've NEVER been able to get CF_SQL_DATE
to work properly.
----- Original Message -----
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 20, 2001 1:27 PM
Subject: Stored Procedure Question
> OK, I have been using SP for a while with no problems. Now I am
encountering an issue. I have a stored procedure that looks like this:
>
> CREATE PROCEDURE Next30Days
> @Next30 DateTime,
> @TodayDate DateTime
> AS
> SELECT Title, Copy, EventDate, EventTime
> FROM Calendar
> Where EventDate < @Next30 And EventDate > @TodayDate
> Order By EventDate, EventTime
> GO
>
> I have my CF code as such:
>
> <!--- Setting the date for 30 days out from today. --->
> <cfset Next30 = DateAdd("d", +30, "#DateFormat(CreateODBCDate(Now()))#")>
>
>
> <cfstoredproc datasource="#Attributes.DataBase#" procedure="Next30Days">
> <cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@Next30" type="In"
value="#Next30#">
> <cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@TodayDate" type="In"
value="#DateFormat(CreateODBCDate(Now()))#">
> <cfprocresult name="Next30Days">
> </cfstoredproc>
>
> And I get this in my browser:
>
> ODBC Error Code = S1C00 (Driver not capable)
>
>
> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
>
>
> SQL = "Next30Days"
>
> Data Source = "EVENTS"
>
>
> I have poured over this SP and the CF code and I cannot see why I am
receiving this. I know that my SQl 2K is working fine because I have other
tables with several (over 100 so far) SP and they all work fine.
>
> Thanks,
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
