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 you're used to having auto-commit turned > on, this can be confusing. I did and I confirmed this by modifying the data, selecting it from the mysql command line client to verify the changes, then running the report again. If I exit the application and then start it again, everything works as expected until the second instance of the report is run. I have a feeling it has something to do with there already being an instance of the report class, but I can't work out how to destroy it and aren't really sure how to remove the references to it either. I added a print statement to the code and it displays a row that doesn't exist any more. Code, output of print statement and result from the mysql client shown below. Andrew Code: #Get all the mileages and add them together for the month: curs.execute('SELECT date, mileage, name FROM mileage, agents WHERE mileage.agent = agent.rowid AND date >= CAST(%s AS DATE) AND date < CAST(%s AS DATE) AND mileage.agent=%s ORDER BY date', (fromdate, todate, agentid)) for row in curs: month = str(row[0])[:7] print row[1], month Output: 100.0 2008-03 MySQL Output just prior to running the report: mysql> select * from mileage; +-------+------------+---------+---------+-------+ | rowid | date | mileage | vehicle | agent | +-------+------------+---------+---------+-------+ | 1 | 2008-04-28 | 875.63 | 3 | 3 | | 2 | 2008-04-28 | 1188.13 | 6 | 6 | | 3 | 2008-04-28 | 676.88 | 4 | 4 | | 4 | 2008-04-21 | 1111.25 | 6 | 6 | | 5 | 2008-04-21 | 1126.88 | 3 | 3 | | 6 | 2008-04-28 | 1029.38 | 7 | 8 | | 7 | 2008-04-21 | 953.13 | 7 | 8 | | 8 | 2008-04-21 | 675.63 | 4 | 4 | | 9 | 2008-04-14 | 891.88 | 3 | 3 | +-------+------------+---------+---------+-------+ 9 rows in set (0.00 sec) As you can see there's no row with a mileage of 100 with the correct month. -- http://mail.python.org/mailman/listinfo/python-list