That was it. Thanks.
---------- Original Message ----------------------------------
From: "Kwang Suh" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 20 Nov 2001 13:28:19 -0700
>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,
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
