Problem updating DATE field in CF

[msng]

I have a field last_update of the type DATE in ORacle.

To update this field with today's date, I am doing as follow:

last_update = #createODBCDate(now())#

However, this gives an error.

What wrong am I doing here? Please help.

 

[TruthInSatire]

my guess is you're not clicking the button hard enough....

what is the error?

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[TruthInSatire]

try:

last_update = ###createODBCDate(now())###

or

last_update = '#createODBCDate(now())#'

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[ecobb]

Try using cfqueryparam in your query. Oracle gets funny with dates sometimes.

last_update = <cfqueryparam value="#Now()#" cfsqltype="CF_SQL_DATE">

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher