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/9999 really means no > data ...) If they run a report, etc. with the data, then you end up with a > nonsensical date like 1/1/9999 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/9999 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