Re: Database Query Contains Old Data

2008-05-21 Thread giraffeboy
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 ad

Re: Database Query Contains Old Data

2008-05-21 Thread giraffeboy
On May 21, 1:49 pm, "Jerry Hill" <[EMAIL PROTECTED]> wrote: > Did you remember to commit your changes before re-running the report? > Python's DB API requires that any auto-commit feature of the > underlying database be turned off by default, so you are required to > commit changes yourself. If y

Database Query Contains Old Data

2008-05-21 Thread giraffeboy
Hi there, I'm having a problem with the Python db api, using MySQL. I've written a program with a GUI using wxPython, the GUI is contained in main.py which imports another module - reports.py. There are several reports that are selected using the gui, and each report is a class in the file report