This is a multi-part message in MIME format.
--------------8677263C964C60C28BB83CC1
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I am confused why I am getting the following error:
ODBC Error Code = 22008 (Datetime field overflow)
[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0180 -
Syntax of date, time, or timestamp value not valid.
SQL = "insert into oimdbadm.assigned (id, date, time, agency, reqtype,
assigned, address, requester, req_email, phone, account_code,
est_start_date, est_comp_date, est_man_hrs, act_start_date,
act_comp_date, act_man_hrs, due_date, title, descrip, comments) values
('3847', '2000-09-28', '01:52:12', 'Employment Services and Training',
'Web Support -- CareerNet', 'Greg Mamayek ', '[EMAIL PROTECTED]
', 'Joe', '[EMAIL PROTECTED]', '410 555-1212', 'Assistant Secretary (DET) --
71100', 'NULL', 'NULL', '0', 'NULL', 'NULL', '0', '2000-10-10', 'Test',
'Testing 1 2 3', '')"
Shouldn't the code below prevent that from happening?
<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>
------------------------------------------------------------
James
--------------8677263C964C60C28BB83CC1
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
--------------8677263C964C60C28BB83CC1--
------------------------------------------------------------------------------
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.
