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
is null. The field is marked not required in ACCESS so it should
accept
nulls. I get a datatype
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
: 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 of the
field
is null. The field is marked not required in ACCESS so it should
accept
nulls. I get
? 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
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
is null
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
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 Message
I cannot update a date/time field within ACCESS when the value of the field
is null. The field is marked not required in ACCESS so it should accept
nulls. I get a datatype mismatch.
Does anyone have a solution for this problem??
Richard Colman
?
-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
9 matches
Mail list logo