> I am trying to do an update to my DB:
> UPDATE BookInventory
> SET Status = 'Checked Out',
> CheckedTo = 'rayb',
> ChgDate = {ts '2003-09-16 16:08:22'}
> WHERE id = 2043
> This worked fine before, I updated my CFMX server to 6.01 and my JDBC
> drivers to 1.4, and am now getting column doesn't exist! Does anyone
> know why this no longer works?
>
I understand that this worked before MX and now it doesn't, but you're using
a completely different set of drivers (Oracle ODBC/Native depending on your
previous CF version vs. JDBC), each with their own set of quirks. As for the
exact reason you're having your problem, not sure, but I'd chalk it up to
the way the JDBC drivers pass dates as opposed to the ODBC/Native drivers.
I've been working with CF and Oracle since the early days of CF and learned
a long time ago to use Oracle's TO_DATE() function around all dates. Oracle
is very particular about date formatting, and this function is the closest
to a silver bullet that I've been able to find. Also, it looks like your
example is using the current date/time to insert. If that's the case, then
use sysdate instead of passing in an ODBC-format date.
Regards,
Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get the mailserver that powers this list at
http://www.coolfusion.com
