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 fi

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

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 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