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)
