Put ' around the value (ie the date) and see if that works
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303
----- Original Message -----
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 26, 2000 3:12 PM
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]
