yes...use the Oracle to_date() around your dates. Also, try using cfqueryparam, it can handle the date conversions automagically.
Doug >-----Original Message----- >From: Dave Carabetta [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 16, 2003 9:54 PM >To: CF-Talk >Subject: Re: Date problem with CFMX and Oracle > > >> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm