Does that work with ACCESS??
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 10:07 AM
To: CF-Talk
Subject: RE: Cannot Update Date/Time field
Use cfqueryparam and set the null attribute dynamically
Pascal
> -Original Mess
t seems like this
> > is a common situation, and I can't seem to come up with a good solution?
> >
> >
> >
> > -Original Message-
> > From: Greg Morphis [mailto:[EMAIL PROTECTED]
> > Sent: Friday, December 10, 2004 10:16 AM
> > To: CF-Ta
this
> is a common situation, and I can't seem to come up with a good solution?
>
>
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 10:16 AM
> To: CF-Talk
> Subject: Re: Cannot Update Date/Time field
&g
can you send your update query?
- Original Message -
From: "Richard Colman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 10, 2004 11:44 AM
Subject: Cannot Update Date/Time field
>I cannot update a date/time field within ACCESS when the value of the field
? Would it happen in SQL-Server. It seems like this
is a common situation, and I can't seem to come up with a good solution?
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, December 10, 2004 10:16 AM
To: CF-Talk
Subject: Re: Cannot Update Date/Time field
You could also use a dummy date.. 1/1/ or something. I did that
when I ran into a similiar situation.
On Fri, 10 Dec 2004 19:06:53 +0100, Pascal Peters <[EMAIL PROTECTED]> wrote:
> Use cfqueryparam and set the null attribute dynamically
>
> Pascal
>
>
>
>
> > -Original Message-
>
Use cfqueryparam and set the null attribute dynamically
Pascal
> -Original Message-
> From: Richard Colman [mailto:[EMAIL PROTECTED]
> Sent: 10 December 2004 18:45
> To: CF-Talk
> Subject: Cannot Update Date/Time field
>
> I cannot update a date/time field within ACCESS when the value
yes, all the non-datetime fields update fine, with or without a null. Only
the date/time fields have this problem. I have tried putting
createodbcdate into the update, but does not make any difference.
> can you send your update query?
>
> - Original Message -
> From: "Richard Colman" <[EM
8 matches
Mail list logo