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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
