Query in CF5 versus MX

hi again,

I wrote a simple query that works in MX but not in CF5.

basically, it loops through the form and deletes records checked in the checkbox field.

Database is Oracle 8i

------------

Error message for CF 5:

Error Diagnostic Information
Oracle Error Code = 911

ORA-00911: invalid character

SQL = "UPDATE TLC_COURSE
SET TLC_COURSEISACTIVE = '0', TLC_COURSEDATEMODIFIED = {ts '2004-08-25 10:32:46'},
TLC_COURSEIP = '127.0.0.1' WHERE WEB_TLC_COURSE.TLC_COURSEID IN (141)"

---------------

Works okay with CFMX... I tried to look up in livedocs for the differences between them but can't find anything.

It can't be an Oracle error because it's using the same database!

only diff is that test platform is CFMX and live one is version 5.

thoughts?

It's probably something related to the JDBC driver that CFMX is using, vs the native driver that CF 5 is using. I bet it's the time stamp. Does removing the time stamp from the update fix the problem?

hi,

interesting.. you were correct. How did you figure that it was specifically the timeformat that caused the trouble?

to update the time , I basically just used #now()#... maybe I use something like createodbcdate but then again, its oracle running on a Nix box

You should be able to use createODBCDate( now() ) with no problem. Or better yet, make the default value in that column in Oracle be the current date/time and you don't even have to worry about it from the CF side.

yeah.. I set the default for the other date/time fields but not this one.. I'll do the same now.

thanks again.