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)
