Re: Help with Simple SQL Insert

2007-09-10 Thread Jochem van Dieten
Aaron Roberson wrote: Query Error: Data truncation: Out of range value adjusted for column 'ordernumber' at row 1 Here is the SQL statement: INSERT INTO orders(ordernumber, tax, shipping, total) VALUES(558972266568040,0.0,4.75,24.7) In my database (MySQL 5) I have the following fields in

Help with Simple SQL Insert

2007-08-30 Thread Aaron Roberson
This just keeps blowing me away. A simple, simple SQL insert statement keeps throwing an error and I can't figure out why. Here is the error message: Query Error: Data truncation: Out of range value adjusted for column 'ordernumber' at row 1 Here is the SQL statement: INSERT INTO

Re: Help with Simple SQL Insert

2007-08-30 Thread Nick de Voil
Aaron Here is the error message: Query Error: Data truncation: Out of range value adjusted for column 'ordernumber' at row 1 Here is the SQL statement: INSERT INTO orders(ordernumber, tax, shipping, total) VALUES(558972266568040,0.0,4.75,24.7) In my database (MySQL 5) I have the

Re: Help with Simple SQL Insert

2007-08-30 Thread Aaron Roberson
Yeah, I just kept bringing the range up on that column because even when I had it at 11 or 25 I kept getting the same data truncated error. I went ahead and changed it to varchar(75) to test it. -Aaron On 8/30/07, Nick de Voil [EMAIL PROTECTED] wrote: Aaron Here is the error message:

RE: Help with Simple SQL Insert

2007-08-30 Thread Robert Harrison
The problem almost certainly lies in the field definitions in the data base tables. I suspect the double values, but I think you should take a look at the int values as well. They look huge. I can't speak to mySQL exactly as I use other DBs, but most DBs compact integer data into binary, so field