Required or not, the empty string is NOT a valid ODBC date. You need to replace it with "NULL" in your query string, usually by doing:
mydatefield = <cfif isdate(mydate)>CreateODBCDate(mydate)<cfelse>null</cfif> 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( ) > > > It is Access, datatype is date/time and it is NOT required. > > Thanks, > > Rob > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of [EMAIL PROTECTED] > Sent: March 6, 2002 12:17 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] createODBCDate( ) > > > Hi Rob, > > If you are using Access and the datatype is "date/time" is > the "required" > attribute set to no? > > > > Dave Seddon (p) 997-1803 > Internet Software Support Specialist > Workplace Information Directorate, HRDC-DRHC > e-mail: [EMAIL PROTECTED] > Web: http://labour.hrdc-drhc.gc.ca > > ---------- Original Text ---------- > > From: "Rob Matlow" <[EMAIL PROTECTED]>, on > 2002-03-06 12:11 PM: > > I've never used CreatedODBC either (no such thing as far as I > no). I am > using createODBCDate(). I don't want now() to be entered. I > want the date > from the form (form.packageDate) to be entered. The problem > is when I don't > enter a date. > > Thanks, > > Rob > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Karl Zarudny > Sent: March 6, 2002 12:01 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] createODBCDate( ) > > > I've never used CreatedODBC but have you tried?.... > CreateODBCDate(#DateFormat(Now())# #TimeFormat(Now())#) > > I might be steering you in the wrong direction - forgive me if I am. > > > From: "Rob Matlow" <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Wed, 6 Mar 2002 11:47:12 -0500 > > To: "CFTALK" <[EMAIL PROTECTED]> > > Subject: [CFTALKTor] createODBCDate( ) > > > > I cannot seem to get a date to properly insert and update into the > database. > > I am using a the createODBCDate( ) function. It works fine > if I put in a > > date but will not work if there is no date entered. It > will not work > > without the createODBCDate( ) function either. How do I get > around this? > > > > CODE > > > > <CFQUERY DATASOURCE="#DSN#"> > > UPDATE contacts > > SET > > packageDate = #CreateODBCDate(Form.packageDate)#, > > WHERE > > contactID = #Form.ContactID# > > </CFQUERY> > > > > > > ERROR > > > > An error occurred while evaluating the expression: > > #CreateODBCDate(Form.packageDate)# > > > > Error near line 24, column 17. > > > -------------------------------------------------------------- > ------------ > -- > > ---- > > Parameter 1 of function CreateODBCDate which is now "" must > be a date/time > > value > > > > > > Thanks, > > > > Rob > > > > > > - > > 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: Karl Zarudny <[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) - 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)
