Setting LOA won't work

[GoogleCodeExporter]

Looks like PHP is passing the value as an int when MySQL wants a string but
behavior is strange. When user inputs loa as 0 the database sets to 0, when
the user inputs loa as 1 the database sets to 0, but when the users inputs
loa as 2 the database sets to 1. The only thing I can think is MySQL is
taking the value as a bool but if that were the case then 1 should equate
to 1 but it doesn't.

If you write the SQL statement as loa = '%s' instead of loa = %s it works.
Not sure if its the most elegant solution but it works.

Original issue reported on code.google.com by david.va...@gmail.com on 4 Aug 2008 at 10:43

[GoogleCodeExporter]

Fixed in r634

Original comment by david.va...@gmail.com on 4 Aug 2008 at 10:47

• Changed state: Fixed

[GoogleCodeExporter]

Additional fix in r638

Original comment by david.va...@gmail.com on 16 Aug 2008 at 9:40