what sort of data feilds are the rows you are putting this stuff into?
datetime, char, varchar, etc...
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 2: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]
