Multiple queries using db.query() raises a _mysql_exceptions.ProgrammingError

[Brian J Ewing]

db.query("INSERT INTO table1 (field1, field2) VALUES ('value', 'value'); UPDATE table2 SET foo='bar'")

This works fine, however a _mysql_exceptions.ProgrammingError is raised:

_mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now") in <bound method Cursor.__del__ of <MySQLdb.cursors.Cursor object at 0x>>

db.query tries to return the result from the last query without first freeing the result of the first, and MySQLdb raises this exception

[Anand Chitipothu (anandology)]

Issue moved to github.

https://github.com/webpy/webpy/issues/issue/34

[Anand Chitipothu (anandology)]

This issue is moved to github.

https://github.com/webpy/webpy/issues/issue/34