This is a multi-part message in MIME format.
--------------F68D756517EC607E868C5C20
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Jim,
Weird. While I would never do this, I decided to drop and re-create the
table since it was only 12 columns. After I did that, it worked like a
champ. Anyway, thanks for the tip, I will keep it in mind for the
future.
James
"Reilly, Jim" wrote:
>
> 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.
--------------F68D756517EC607E868C5C20
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
--------------F68D756517EC607E868C5C20--
------------------------------------------------------------------------------
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.
