Ibelieve you will find that a blank date is not valid, you will have to use NULL instead, which equates to the date being not defined, which seems to be what you are really wanting.
Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Rob Matlow > Sent: Wednesday, March 06, 2002 12:20 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] createODBCDate( ) > > > Nothing, I want it blank. > > Thanks, > > Rob > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of rudy > Sent: March 6, 2002 12:20 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] createODBCDate( ) > > > > The problem is when I don't enter a date. > > what date do you want the update to set in that case? > > rudy > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "rudy" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Rob Matlow" > <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
