Database Query Contains Old Data

[giraffeboy at gmail.com]

On May 21, 3:23 pm, Paul Boddie <p... at boddie.org.uk> 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!