database have built in functions for getting the current date, so you don't need to use CF.
e.g. for sql server use editdate - getDate() On Fri, May 6, 2011 at 9:21 PM, Nicki Tabb <vnt...@alaska.edu> wrote: > > Turns out what is causing the error is the line > > EditDate=<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> > > the EditDate is a datetime field. > > Any ideas? > > thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm