Re: MySQL from Python Error

2004-06-27 Thread Paul DuBois
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

Re: MySQL from Python Error

2004-06-27 Thread Michael Stassen
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=

MySQL from Python Error

2004-06-26 Thread Paul Maine
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