>Why are you even updating it - if you're just setting it back to the same
>created date? Also, you can use oracles default "sysdate" right in your
>table definition so that you don't have to add a date at all - if you are
>really just tracking the added date and not the updated date.
I'm updat
not the updated date.
- Original Message -
From: "daniel kessler" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, December 20, 2004 7:19 AM
Subject: Re: updating my date_added from a form fails
> Thanks Charlie, that worked great.
> I guess I assumed that since form v
> > From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> > Sent: 20 December 2004 15:09
> > To: CF-Talk
> > Subject: Re: updating my date_added from a form fails
> >
> > try wrapping Form.date_added in a createODBCDateTime() function (or
> > just a createODBCDate()
Or even better, use cfqueryparam
> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: 20 December 2004 15:09
> To: CF-Talk
> Subject: Re: updating my date_added from a form fails
>
> try wrapping Form.date_added in a createODBCDateTime()
Thanks Charlie, that worked great.
I guess I assumed that since form value "" works fine as a number, date
would do the same. Guess it works this way since date is more complex.
I appreciate the help. May your code go smoothly today.
>try wrapping Form.date_added in a createODBCDateTime() func
try wrapping Form.date_added in a createODBCDateTime() function (or
just a createODBCDate() if you don't need time).
On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I have an Oracle database with a record where when I update it with
> now() it works. From that poi
I have an Oracle database with a record where when I update it with
now() it works. From that point on, for editing, I carry the
date_added through a hidden form field which has the source of
When I try and use that hidden form field with the date to update the
record, I get the following err
7 matches
Mail list logo