Greetings,
I'm always having problems with dates,
this is what I'm doing,
I'm wrapping CREATEODBCDATETIME around my date time variable,
so the date scope defaults to 1899-12-30,
<CFSET
FILTERTimeFrom=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hour,ATTRIBUTES.minu
te,00))>
<CFSET
FILTERTimeTo=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hourTo,ATTRIBUTES.minu
teTo,00))>
which looks like this,
{ts '1899-12-30 11:30:00'} {ts '1899-12-30 18:30:00'},
Inside proc I gave Datetime Datatype,
@TimeFrom DATETIME
@TimeTo DATETIME
on calling the stored proc,
<CFSTOREDPROC
PROCEDURE="p_build_from_historyIDAndFilterTime"
DATASOURCE="#REQUEST.dsn#"
USERNAME="#REQUEST.user#"
PASSWORD="#REQUEST.key#">
<CFPROCRESULT NAME="q_getTop1" RESULTSET="1">
<CFPROCPARAM DBVARNAME="@customerID" VALUE="#SESSION.CUSTOMERID#"
CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@VehicleID" VALUE="#ATTRIBUTES.CALLSIGN#"
CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@Date" VALUE="#ATTRIBUTES.reportDate#"
CFSQLTYPE="CF_SQL_INTEGER" TYPE="IN">
<CFPROCPARAM DBVARNAME="@TimeFrom" VALUE="#FILTERTimeFrom#"
CFSQLTYPE="CF_SQL_DATE" TYPE="IN">
<CFPROCPARAM DBVARNAME="@TimeTo" VALUE="#FILTERTimeTo#"
CFSQLTYPE="CF_SQL_DATE" TYPE="IN">
</CFSTOREDPROC>,
I get this error,
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented,
so then I tried the TIMESTAMP datatype changing from CF_SQL_DATE to
CF_SQL_TIMESTAMP,
<CFPROCPARAM DBVARNAME="@TimeFrom" VALUE="#FILTERTimeFrom#"
CFSQLTYPE="CF_SQL_TIMESTAMP" TYPE="IN">
<CFPROCPARAM DBVARNAME="@TimeTo" VALUE="#FILTERTimeTo#"
CFSQLTYPE="CF_SQL_TIMESTAMP" TYPE="IN">
and inside the proc to,
@TimeFrom TIMESTAMP
@TimeTo TIMESTAMP
BUT ALSO GOT [Microsoft][ODBC SQL Server Driver]Optional feature not
implemented
any ideas
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
