I get this error when I run my stored proc
ODBC Error Code = S1C00 (Driver not capable)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
this is the SP
(
@DateFrom INT,
@DateTo INT,
@TimeTo TIMESTAMP,
@TimeFrom TIMESTAMP
)
AS
SELECT *
FROM AbbeyFealeAlerts
WHERE DATEDIFF(DAY,dt,GETDATE()) >= @DateTo
AND DATEDIFF(DAY,dt,GETDATE()) <= @DateFrom
AND DATEPART(HOUR, DT) >= DATEPART(HOUR,@TimeFrom)
AND DATEPART(HOUR, DT) <= DATEPART(HOUR,@TimeTo)
ORDER BY DT DESC
this is how I'm calling it,
<CFSTOREDPROC
PROCEDURE="p_Run_Filter2"
DATASOURCE="#REQUEST.dsn#"
USERNAME="#REQUEST.user#"
PASSWORD="#REQUEST.key#">
<CFPROCRESULT NAME="q_Filter_Result_Set"
resultset="1">
<CFPROCPARAM DBVARNAME="@DateFrom"
VALUE="#CALLER.ATTRIBUTES.getDateFrom#" CFSQLTYPE="CF_SQL_INTEGER"
TYPE="IN">
<CFPROCPARAM DBVARNAME="@DateTo"
VALUE="#CALLER.ATTRIBUTES.getDateTo#" CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@TimeTo"
VALUE="#CALLER.ATTRIBUTES.CTimeTo#" CFSQLTYPE="CF_SQL_TIME" TYPE="IN">
<CFPROCPARAM DBVARNAME="@TimeFrom"
VALUE="#CALLER.ATTRIBUTES.CTimeFrom#" CFSQLTYPE="CF_SQL_TIME" TYPE="IN">
</CFSTOREDPROC>
and these are the values of @TimeTo and @TimeFrom
{ts '1899-12-30 15:00:00'} {ts '1899-12-30 16:00:00'}
Thanx again
J
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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
