On May 21, 3:23 pm, Paul Boddie <[EMAIL PROTECTED]> wrote: > Note that if you have a connection open in your program, especially if > that connection has already been used to select data, it may be the > case that you then have to perform a rollback or commit before > attempting to access newly added data. The reason for this behaviour > is that the DB-API modules will have begun a transaction on your > behalf, and while that transaction is open, changes committed in other > transactions may be unavailable to your own transaction, depending on > the transaction isolation level.
Thanks for that Paul, seems to have solved the problem perfectly. I had always just thought querying a database would always give you the most current data, guess it just goes to show that things are never as simple as they first appear! -- http://mail.python.org/mailman/listinfo/python-list
