I'll bet he used Now() outside of cfqueryparam, which of course would not work because Now() is a cf function, and getDate() is a transact-sql function.
But *THIS* would work: <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> Rick On Tue, Oct 13, 2009 at 5:39 PM, Leigh <[email protected]> wrote: > >> Now() didn't work, but getdate() did. Thank you. > > Weird. While I would not expect an issue, maybe it was related the > cf_sql_timestamp? I do not use odbc socket connections. So I am not sure how > that type is handled.. > > -Leigh > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327157 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
