James,
REXX is an IBM programming language (runs interpretative, not compiled),
and runs on all IBM OS's like AS400, OS/2, VM, MVS, etc...
REXX is to those OS's as Basic is to DOS, yet has some parsing
power of perl.
Anyway, sound like the datatypes are incorrectly passed from your
SQL statements to the types of the database fields. (ie: if
ID is numeric remove the ' ' and/or the date fields are Date type,
then also remove the ' ', thus:
'#date#' becomes '#date# and
'#form.id#' becomes #form.id#
Hope this helps!
Jim
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 11:17 AM
To: CF-Talk
Subject: Need some help here, unknown error SQL 7008N
This is a multi-part message in MIME format.
--------------327729A9AA7CC339FC1F4ECE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I checked to see what the error meant and it said this:
SQL7008N REXX variable "<variable>" contains inconsistent data.
Cause: A variable that contained inconsistent data was passed to REXX.
The command cannot be processed.
Action: If the variable is an SQLDA, verify that the data and length
fields have been assigned correctly. If it is a REXX variable, verify
that the type of data is appropriate to the command where it is being
used.
What is a REXX varible anyway?
I checked my data types and lengths and they all check out. What could
be causing this error??? I am using AS/400 on the back-end.
<cfquery name="NewRequest" datasource="OIMDBADM">
insert into oimdbadm.newreq (time, date, agency, reqtype,
requester, req_email, phone, due_date, title, descrip, id, assigned)
values ('#time#', '#date#', '#form.agency#', '#form.reqtype#',
'#form.requester#', '#form.req_email#', '#form.phone#',
'#form.due_date#', '#form.title#', '#form.descrip#', '#form.id#',
'#form.assigned#')
</cfquery>
--------------327729A9AA7CC339FC1F4ECE
Content-Type: text/x-vcard; charset=us-ascii;
name="jtaavon.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for James Taavon
Content-Disposition: attachment;
filename="jtaavon.vcf"
begin:vcard
n:Taavon;James
tel;cell:(443) 506-2117
tel;fax:(410) 333-5203
tel;work:(410) 767-3415
x-mozilla-html:FALSE
org:Department of Labor, Licensing and Regulation;Office of Information and
Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Web Developer
adr;quoted-printable:;;1100 N. Eutaw Street,=0D=0ARoom
203;Baltimore;MD;21201;
fn:James Taavon
end:vcard
--------------327729A9AA7CC339FC1F4ECE--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
