The "optional feature not implemented" message iirc occurs when sql server
receives a string instead of a datetime value ... also, afaik, a timestamp
is supposed to be a uniquely identifying variable, so you shouldn't use them
unless the plan is to use it as the or a unique id for the table... I
remember getting error messages ( maybe from Access ) that said I couldn't
have more than one timestamp column in a given table and then reading the
other info about timestamps to figure out why...
In any event, this was one of the big reasons I stopped using <cfstoredproc>
at the time, however, I'd be willing to bet that it will work, if you change
your input variables for the procedure to varchar(20) and then use
CONVERT(datetime,@timefrom) to insert or update the date column in the
table. You should still use CreateODBCDateTime in your CF, but the
<cfprocparam> tag will use cf_sql_varchar instead of cf_sql_datetime ...
hth
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> 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.ho
> ur,ATTRIBUTES.minu
> te,00))>
> <CFSET
> FILTERTimeTo=CREATEODBCDATETIME(CreateTime(ATTRIBUTES.hour
> To,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/cf-talk@houseoffusion.com/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
