Using cf_sql_date will truncate the time. You want to use cf_sql_timestamp. -d
----- Original Message ----- From: "Brad Howerter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 17, 2003 10:10 AM Subject: Re:Date problem with CFMX and Oracle > 6.1 makes a change that breaks code like this. This was already covered on a different mailing list. > > See http://www.mail-archive.com/[EMAIL PROTECTED]/msg01644.html for details. > > You'd do well to use <cfqueryparam> with a cfsqltype of cf_sql_date and/or use oracle's TO_DATE function as the other repliers have suggested. > > >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? > > > >Ray Bujarski > >Direct 858-845-7669 > >Pager 858-636-9900 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137320 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
