At 19:08 -0700 6/26/04, Paul Maine wrote:
I encountered the following error when trying to perform a SQL UPDATE to a
MySQL database table from Python.
I would apprciate any assistance. In the Python code I have tried integer
and decimal format specifiers in addition to the string specifier and
noth
I've not used Python, but it looks like the query has invalid syntax once it
gets to mysql. The last error line is the key:
1064, "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'139.80'' WHERE competitorID=
I encountered the following error when trying to perform a SQL UPDATE to a
MySQL database table from Python.
I would apprciate any assistance. In the Python code I have tried integer
and decimal format specifiers in addition to the string specifier and
nothing worked.
Traceback (most recent call