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
-~----------~----~----~----~------~----~------~--~---
