yeah, something like that. any visual query builder that can access the
database you are querying. I belive you said it is an AS400... do you have
access to the PF, LF, or RPG files on that server (or to the people who
wrote them)? PF or LF Type Files would give you a very clear description of
how the AS400 database is set up (a PF File is a physical file...which
basically describes the data itself, and an LF File is a logical file...it
shows table joins). RPG Code might give you insite, if you can find a good
example of an insert or update (an RPG File is similar to a stored procedure
for purpose of this discussion). If you can access the AS400 menu, but
don't know where to start, try finding subfiles and trace the file execution
path from there (a subfile is just a data-display or data entry screen).
Hopefully, it won't come to any of that...you can try a visual builder or
talk with one of the RPG Programmers there. If nothing else, anyone reading
this who knows absolutely nothing about programming and databases on the
AS400, does now.
~Simon
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 3:27 PM
To: CF-Talk
Subject: Re: NEED HELP!! Ignore Previously SQL Error I posted. New SQL
Error 408
This is a multi-part message in MIME format.
--------------4FB7B0DD43D4F9E2FDA1BF6B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
You mean like using SQL Query Builder in Studio? The problem there is
that I am unable to setup a connection with the remote database. At
least I think I cant. I will try.
Simon Horwith wrote:
>
> do you have any sort of visual query builder available to you, for
> debugging, etc.? I'd try that if you're getting a lot of errors...just to
> get a good example or two if nothing else.
>
> ~Simon
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 26, 2000 3:12 PM
> To: CF-Talk
> Subject: NEED HELP!! Ignore Previously SQL Error I posted. New SQL Error
> 408
>
> This is a multi-part message in MIME format.
> --------------294808483026881139F5AB7E
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Ok, I understand what the error is saying, but I can't figure why it is
> saying it. All my columns are set to the proper data types. I am really
> getting tired of getting all these errors. I am sorry for filing up the
> messages with all of them.
>
> Thanks in advance for the help.
>
> DB2 Error Code = -408
>
> [IBM][CLI Driver][AS] SQL0408N An UPDATE, INSERT, or SET
> transition-variable value is not compatible with the data type of its
> target column "EST_START_DATE". SQLSTATE=42821
>
> SQL = "update oimdbadm.assigned set est_start_date = 10/31/2000,
> est_comp_date = 10/31/2000, est_man_hrs = '1', act_start_date =
> 10/31/2000, act_comp_date = 10/31/2000, act_man_hrs = '1',
> staff_comments = 'Test' where id = '1006'"
>
> Data Source = "OIMDBADM"
>
> SQL = "update oimdbadm.assigned set est_start_date = 10/31/2000,
> est_comp_date = 10/31/2000, est_man_hrs = '1', act_start_date =
> 10/31/2000, act_comp_date = 10/31/2000, act_man_hrs = '1',
> staff_comments = 'Test' where id = '1006'"
>
> The error occurred while processing an element with a general identifier
> of (CFQUERY), occupying document position (33:1) to (33:46) in the
> template file oim_edit_action.cfm
>
> UPDATE FILE (oim_edit_action.cfm)
>
> <CFQUERY NAME="updater" datasource="OIMDBADM">
> update oimdbadm.assigned
> set est_start_date = #form.est_start_date#,
> est_comp_date = #form.est_comp_date#,
> est_man_hrs = '#form.est_man_hrs#',
> act_start_date = #form.act_start_date#,
> act_comp_date = #form.act_comp_date#,
> act_man_hrs = '#form.act_man_hrs#',
> staff_comments = '#form.staff_comments#'
> where id = '#form.id#'
> </CFQUERY>
> --------------294808483026881139F5AB7E
> 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
>
> --------------294808483026881139F5AB7E--
>
>
----------------------------------------------------------------------------
> --------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
----------------------------------------------------------------------------
--------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
--------------4FB7B0DD43D4F9E2FDA1BF6B
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
--------------4FB7B0DD43D4F9E2FDA1BF6B--
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
