Re: Need Help Badly...Datetime Overflow Error

I would also caution you not to use words like "date," "time," and "id" as your column names. Try to get a bit more specific - startdate, starttime, fieldid, so that you're not using those "default" words which are often reserved words. -HTH -d *

Re: Need Help Badly...Datetime Overflow Error

This is a multi-part message in MIME format. --32E36A3E87FB3A70B9927A3E 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 SQ

RE: Need Help Badly...Datetime Overflow Error

ausing the error. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 2:30 PM To: CF-Talk Subject: Re: Need Help Badly...Datetime Overflow Error This is a multi-part message in MIME format. --F98F922C00E61B9D84AA5081 Content-

Re: Need Help Badly...Datetime Overflow Error

This is a multi-part message in MIME format. --1AFA34D4BC9B353E9806196E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit OOPS!!! IT WORKED!! HOW COME I DID NOT THINK OF THAT! James Taavon wrote: > > This is a multi-part message in MIME format. > --

Re: Need Help Badly...Datetime Overflow Error

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 SQ

RE: Need Help Badly...Datetime Overflow Error

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,