Nope.
Removing Single Quotes gives me the REXX error again. The variable
"SUB00001" is actually the table name SUBMISSIONS. Could table length
name have an impact on this problem? Is DB2 AS/400 limited to lengths
for table names?
DB2 Error Code = -7008
[IBM][CLI Driver][AS] SQL7008N REXX variable "SUBMI00001" contains
inconsistent data. SQLSTATE=55019
Data Source = "lsar_prod"
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-10'}, {d '2001-05-02'}, '', '', '', '', '', 'Sandy Crisafulli',
{d '2001-05-12'}, NULL, '', '10006.pdf', '', 'Sandy Crisafulli',
'Incomplete')"
"DeVoil, Nick" wrote:
>
> Lose the apostrophes round
> '#CreateODBCDate(form.date_assigned)#'
>
> Nick
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 3:06 AM
> To: SQL
> Subject: Repost with Proper Subject Line: Problems with inserting a date
> fields (Using Native Driver, AS/400)
>
> 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/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
