James Taavon wrote:
>
> Hello.
>
> I posted this in CF-Talk list. Looking for some assistance.
>
> 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/pdf"
> 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
