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