You don't need createODBCDateTime() for that as NOW() is a datetime stamp as it is
In any case, that's a CFQUERYPARAM best practise which is it is "best practise" to use CFQUERYPARAM anyway -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrew Sent: Friday, 15 May 2009 12:13 PM To: cfaussie Subject: [cfaussie] CreateODBCDateTime best practice? Hi, What's the recommended practice for using CreateODBCDateTime? <cfquery ...> update tablename set datefield = #CreateODBCDateTime(now())# where .... </cfquery> or <cfquery ...> update tablename set datefield = <cfqueryparam value = "#CreateODBCDateTime(now())#" type="CF_SQL_TIMESTAMP"> where .... </cfquery> or doesn't it really matter? I've noticed both work on Oracle, but will they work anywhere? Thanks, Andrew. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
