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 <[EMAIL PROTECTED]> 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 > -- http://mail.python.org/mailman/listinfo/python-list