This is a multi-part message in MIME format.
--------------B31CB0E7B32B19014552BCF4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I am am getting a Column not found error and dont know why. I am
evaluating a date field and resetting the variable to NULL if it is
empty by default. This has worked on another application, but it not
working here. The only difference between the two apps is the back-end.
The one that works is DB2/NT and the one that is giving me problems is
AS/400.
Code below.
<cfif #est_start_date# IS NOT "">
<cfset str_est_start_date = "#est_start_date#">
<cfelse>
<cfset str_est_start_date = "NULL">
</cfif>
<cfif #est_comp_date# IS NOT "">
<cfset str_est_comp_date = "#est_comp_date#">
<cfelse>
<cfset str_est_comp_date = "NULL">
</cfif>
<cfif #act_start_date# IS NOT "">
<cfset str_act_start_date = "#act_start_date#">
<cfelse>
<cfset str_act_start_date = "NULL">
</cfif>
<cfif #act_comp_date# IS NOT "">
<cfset str_act_comp_date = "#act_comp_date#">
<cfelse>
<cfset str_act_comp_date = "NULL">
</cfif>
<cfquery name="Assign" datasource="OIMDBADM">
insert into oimdbadm.assigned (id, date, time, agency, reqtype,
assigned, address, requester, req_email, phone, account_code,
str_est_start_date, str_est_comp_date, est_man_hrs, str_act_start_date,
str_act_comp_date, act_man_hrs, due_date, title, descrip, comments)
values ('#form.id#', '#date#', '#time#', '#agency#', '#reqtype#',
'#form.assigned#', '#form.address#', '#requester#', '#req_email#',
'#phone#', '#form.account_code#', '#str_est_start_date#',
'#str_est_comp_date#', '#est_man_hrs#', '#str_act_start_date#',
'#str_act_comp_date#', '#act_man_hrs#', '#due_date#', '#title#',
'#descrip#', '#comments#')
</cfquery>
ODBC Error Code = S0022 (Column not found)
[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0206 -
Column STR_EST_START_DATE not in specified tables.
SQL = "insert into oimdbadm.assigned (id, date, time, agency, reqtype,
assigned, address, requester, req_email, phone, account_code,
str_est_start_date, str_est_comp_date, est_man_hrs, str_act_start_date,
str_act_comp_date, act_man_hrs, due_date, title, descrip, comments)
values ('1200', '2000-09-28', '02:10:26', 'Labor Market Analysis', 'Web
Support -- DLLR', 'James Taavon ', '[EMAIL PROTECTED]', 'John',
'[EMAIL PROTECTED]', '410 334-2821', 'Administration -- 72201', 'NULL',
'NULL', '0', 'NULL', 'NULL', '0', '2000-10-01', 'Testing', 'Testing
again yes I am.', 'Additional comment field test.')"
Any ideas? Thanks in advance.
--------------B31CB0E7B32B19014552BCF4
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
--------------B31CB0E7B32B19014552BCF4--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
