Re: Cannot Update Date/Time field

2004-12-10 Thread colman
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

RE: Cannot Update Date/Time field

2004-12-10 Thread Pascal Peters
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

Re: Cannot Update Date/Time field

2004-12-10 Thread Greg Morphis
: 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

RE: Cannot Update Date/Time field

2004-12-10 Thread Richard Colman
? 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

Re: Cannot Update Date/Time field

2004-12-10 Thread Jason Herbolsheimer
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

Re: Cannot Update Date/Time field

2004-12-10 Thread Greg Morphis
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

RE: Cannot Update Date/Time field

2004-12-10 Thread Richard Colman
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

Cannot Update Date/Time field

2004-12-10 Thread Richard Colman
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

Re: Cannot Update Date/Time field

2004-12-10 Thread Greg Morphis
? -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