>
>Try CFSQLTYPE="CF_SQL_TIMESTAMP"
>
>Steve
>
>
>-----Original Message-----
>From: John mccosker [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, February 25, 2004 9:57 AM
>To: CF-Talk
>Subject: stored proc error with MX
>
>
>hi,
>
>is there some reason why I can't add a date object via a stored proc in MX
>6.1.
>
>example,
>
><cfset offRoadStart = CreateDateTime(Year(now()),
>month(now()),
>day(now()),
>hour(now()),
>minute(now()),
>00)>
>
>then,
>
><!---parameter passed with others, this is the only one giving me the
>problem--->
><CFPROCPARAM DBVARNAME="@OFFROADSTART" VALUE="#offRoadStart#"
>CFSQLTYPE="CF_SQL_DATE" TYPE="IN">
>
>I get this error,
>
>{Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
>Driver]Optional feature not implemented
>
>java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
>Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented
>
>I had a look at JavaCast thinking I was'nt passing in a proper date object,
>even though I am, but javaCast has not data type support for date objects.
>
>any ideas,
>
>john.
> _____
Thanks Steve,
that worked for me.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
