> What cfsqltype in a cfqueryparam should I use to insert now() into a > mySql database (datetime data type) so it keeps the date and time? cf_sql_timestamp. You might double check your syntax and the data type. It works fine for me.
INSERT INTO Table (DateTimeColumn) VALUES ( <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> ) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:322919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
