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 reports.py. These classes contain a method which is passed data as arguments and produces a report, writing HTML to a file and using matplotlib to create a graph file. The report class methods are called from the GUI using the following code: agentlist = self.getselected() detail = self.cb1.GetValue() if self.getdates() != False: fromdate, todate = self.getdates() app.mainframe.SetStatusText("Generating Report...") if self.reportchoice.GetSelection() == 0: thereport = reports.VehicleRunningCost() thereport.producereport(agentlist, fromdate=fromdate, todate=todate, detail=detail) app.mainframe.SetStatusText("Report Complete") viewerframe = ViewerFrame(None, -1, "Mileage and Fuel Report Viewer") viewerframe.Show(True) The first time you run a report, everything works as expected but if you run it a second time, after modifying data, it seems that the data from before the modification is selected on the second report run. It would be much appreciated if anyone could give me any hints as to why the old data is selected. I haven't posted the full code because it's quite long but will post more if anyone wants to see specific parts. Thanks! Andrew -- http://mail.python.org/mailman/listinfo/python-list