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.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to