RE: Cannot Update Date/Time field
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- > 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 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 > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cannot Update Date/Time field
BTW I quick search on google yielded. http://www.experts-exchange.com/Databases/Q_20657164.html apparently it's possible to set date values to null in Access On Fri, 10 Dec 2004 13:21:03 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > If you're talking about CF output, use an if statement to check the > date for the dummy date.. if it is they display or something. > > > > > On Fri, 10 Dec 2004 10:53:01 -0800, Richard Colman <[EMAIL PROTECTED]> wrote: > > Yes, I tried that, but it is ugly. When the user looks at the update, you > > see a dummy listing that has to be explained (e.g. 1/1/ really means no > > data ...) If they run a report, etc. with the data, then you end up with a > > nonsensical date like 1/1/ in the report. > > > > Is this an ACCESS thing? 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- > > > > 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 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cannot Update Date/Time field
If you're talking about CF output, use an if statement to check the date for the dummy date.. if it is they display or something. On Fri, 10 Dec 2004 10:53:01 -0800, Richard Colman <[EMAIL PROTECTED]> wrote: > Yes, I tried that, but it is ugly. When the user looks at the update, you > see a dummy listing that has to be explained (e.g. 1/1/ really means no > data ...) If they run a report, etc. with the data, then you end up with a > nonsensical date like 1/1/ in the report. > > Is this an ACCESS thing? 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- > > > 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 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 > > > > > > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187061 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cannot Update Date/Time field
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. 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 > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187045 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cannot Update Date/Time field
Yes, I tried that, but it is ugly. When the user looks at the update, you see a dummy listing that has to be explained (e.g. 1/1/ really means no data ...) If they run a report, etc. with the data, then you end up with a nonsensical date like 1/1/ in the report. Is this an ACCESS thing? 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- > > 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 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 > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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- > > 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 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 > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187051 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cannot Update Date/Time field
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 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 > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187050 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Cannot Update Date/Time field
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" <[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. 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 >> >> >> >> >> > > ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187048 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 mismatch. Does anyone have a solution for this problem?? Richard Colman ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
