MySQLdb - Query/fetch don't return result when it *theorically* should

[Bernard Lebel]

I'm absolutely flabbergasted.

Your suggestion worked, the loop now picks up the changed values, and
without the need to reconnect.

It's the first time I have to commit after a query, up until I wrote
this program, I used commit() was for UPDATE/INSERT types of commands
only, and always got proper fetch results.


Thanks
Bernard



On 1/18/06, Stephen Prinster <prinster at mail.com> wrote:
> Have you tried doing a "connection.commit()" after each query attempt?
> I believe mysqldb also has a connection.autocommit feature.
> --
> http://mail.python.org/mailman/listinfo/python-list
>