This is a multi-part message in MIME format.
--------------F98F922C00E61B9D84AA5081
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
This is what I get back
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,
completed) values ('1005', '2000-10-25', '02:03:59', 'Employment &
Training', 'Web Support -- CareerNet', 'Greg Mamayek ',
'[EMAIL PROTECTED] ', 'James Bond', '[EMAIL PROTECTED]', '410
555-1212', 'Assistant Secretary (DET) -- 71100', NULL, NULL, '0',
'NULL', 'NULL', '0', '2000-10-31', 'Testing', 'Testing', '',
'Incomplete')"
"Hayes, David" wrote:
>
> As a first step, I would remove the single quotes from around your date
> values in the query statement.
>
> Also, output your query string to the screen so you can see what is actually
> being submitted to the db.
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 25, 2000 1:33 PM
> To: CF-Talk
> Subject: Need Help Badly...Datetime Overflow Error
>
> This is a multi-part message in MIME format.
> --------------D466D3B5107DDC4674AB907F
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Ok,
>
> I can't seem to get this problem figured out. Code is below. I
> previously had a CF application with DB2/NT running on the back-end.
> Everything worked just fine. I now transferred/recreated the database on
> an AS/400 system. Using DB2 Connect to communicate between CF (running
> on Solaris) and the AS/400 machine.
>
> I am getting a Datetime overflow error when assigning NULL values for
> date fields. This worked fine on DB2/NT, but the AS/400 does not like
> it. I have also made sure that my fields are setup to accept null
> values. Does anyone have any experience with this?
>
> I am passing these values though to the action file for insertion in to
> the database, note the "" indicating NULL value.
> <input type="hidden" name="est_start_date" value="">
> <input type="hidden" name="est_comp_date" value="">
> <input type="hidden" name="act_start_date" value="">
> <input type="hidden" name="act_comp_date" value="">
>
> I then evaluate the values of each field in the action file before the
> SQL INSERT.
>
> <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>
>
> The INSERT query
>
> <cfquery name="Assign" datasource="OIMDBADM">
> 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,
> completed)
>
> values ('#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#', '#form.comments#', '#form.completed#')
> </cfquery>
> --------------D466D3B5107DDC4674AB907F
> 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
>
> --------------D466D3B5107DDC4674AB907F--
>
> ----------------------------------------------------------------------------
> --------------------
> 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]
--------------F98F922C00E61B9D84AA5081
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
--------------F98F922C00E61B9D84AA5081--
------------------------------------------------------------------------------------------------
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]