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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
