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 Mess

Re: Cannot Update Date/Time field

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

Re: Cannot Update Date/Time field

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

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

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

Re: Cannot Update Date/Time field

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

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 colman
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