LOL ok if I had used cfsqltype="cf_sql_date" that would have helped too :) had copy/pasted <cfqueryparam cfsqltype="cf_sql_varchar" value="" /> a few too many times. TGIF!
-----Original Message----- From: Paul Kukiel [mailto:[email protected]] Sent: Friday, December 18, 2009 2:35 PM To: cf-newbie Subject: RE: inserting dates This should do the trick: <cfset someDate = "12/18/2009" /> <cfqueryparam cfsqltype="cf_sql_date" value="#createOdbcDate(someDate)#" /> Paul. -----Original Message----- From: Imperial, Bob [mailto:[email protected]] Sent: Friday, December 18, 2009 2:22 PM To: cf-newbie Subject: inserting dates Hi folks, Can some shed some light on how you would insert a date from a form that has this format 12/18/2009 into a mysql datetime column please? I get the following error: Error Executing Database Query. Data truncation: Incorrect datetime value: '05/26/1954' for column 'dob' TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4927 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
