On Mon, 2008-02-04 at 19:53 +0100, Frank Aune wrote: > No, you obviously need to commit your changes before closing the cursor. I'm > surprised if your code above even works if adding content to the db.
Why is that obvious? Is this some MySQL-specific oddity? In other databases, it's the cursor's execute() method that adds the content to the db (pending a commit of the transaction), and closing the cursor simply means that you are explicitly releasing the resources that the cursor used. Whether the cursor is closed before or after the transaction is committed, or even whether the cursor is explicitly closed at all or not, should make no difference whatsoever. -- Carsten Haese http://informixdb.sourceforge.net -- http://mail.python.org/mailman/listinfo/python-list
