This is a multi-part message in MIME format.
--------------46E6CC4E93010FE7E8BA65C5
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
William,
ok, that worked...
But now I get my other error back SQL error 7008, inconsistent data?
How do I know when or when not to use songle quotes?
[IBM][CLI Driver][AS] SQL7008N REXX variable "ASSIGNED " contains
inconsistent data. SQLSTATE=55019
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', assigned = 'James Taavon',
staff_comments = ' ' 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', assigned = 'James Taavon',
staff_comments = ' ' where id = '1006'"
William J Wheatley wrote:
>
> 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/[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]
--------------46E6CC4E93010FE7E8BA65C5
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
--------------46E6CC4E93010FE7E8BA65C5--
------------------------------------------------------------------------------------------------
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]
