>Is the column a date or a varchar - because you're using a varchar cfsqltype. > >I usually use the Oracle to_date() function to insert a date/time. > >mxAjax / CFAjax docs and other useful articles: >http://www.bifrost.com.au/blog/ >>
I use MS SQL Server, but I think you could use something like this. <cfqueryparam value="#now()#" CFSQLType="cf_sql_timestamp" /> If this doesn't work, try this... <cfqueryparam value="#CreateODBCTime(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:325522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4