Don't put quotes around the CreateODBCDate function -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 9:58 AM To: CF-Talk Subject: Problems with inserting a date fields (Using Native Driver, AS/400) Can anybody tell me why I am getting this error? Thanks, James <cffile action="UPLOAD" filefield="documents" destination="/inq2/netscape/suitespot/intranet-docs/dllr/secured-docs/lsar/p df" nameconflict="OVERWRITE"> <cfif #date_closed# IS NOT ""> <cfset str_date_closed = "#date_closed#"> <cfelse> <cfset str_date_closed = "NULL"> </cfif> <cfquery name="NewCase" datasource="lsar_prod"> insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('#form.lid#', '#form.assignedto#', '#form.constituent#', '#CreateODBCDate(form.doc_date)#', '#CreateODBCDate(form.dead_date)#', '#form.subtype#', '#form.subject#', '#form.subjdetail#', '#form.received#', '#form.tone#', 'Sandy Crisafulli', '#CreateODBCDate(form.date_assigned)#', #str_date_closed#, '#form.addressedto#', '#File.ServerFile#', '#form.draft#', 'Sandy Crisafulli', 'Incomplete') </cfquery> IBM][CLI Driver][AS] SQL0104N An unexpected token "2001" was found following "". Expected tokens may include: ") ,". SQLSTATE=42601 SQL = "insert into lsar.submissions (lid, assignedto, constituent, doc_date, dead_date, subtype, subject, subjdetail, received, tone, enteredby, date_assigned, date_closed, addressedto, documents, draft, assignedby, completed) values ('10006', 'Barry Rubin', '', '{d '2001-05-11'}', '{d '2001-05-09'}', '', '', '', '', '', 'Sandy Crisafulli', '{d '2001-05-03'}', NULL, '', '10006.pdf', '', 'Sandy Crisafulli', 'Incomplete')" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
