Hi, Your column comid is probably declared as a tinyint which has a range between -128 and 127 (for not UNSIGNED column). If you want to allow larger values, change the column type accordingly.
(Take a look here : http://www.mysql.com/doc/C/o/Column_types.html ) Regards, Jocelyn Fournier ----- Original Message ----- From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 4:46 PM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's because of MySQL. > I have a value I am inserting into a database and above and below my query I > can echo out the value and it is correct, but the query keeps assuming it is > "127" No matter what I do, I've renamed the variable, renamed the field, > changed my INSERT syntax a couple of times. 127, 127 ,127. MySQL is just > making up this number, there is no place it could get it. > > More detailed explanation is here: > > http://www.sitepointforums.com/showthread.php?s=&postid=477502 > > Check out the thread, if I don't have absolute proof of a MySQL bug then I > don't think such proof would be possible to get. > > Chris Beasley > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
