On Thu, Feb 4, 2010 at 12:47 PM, Alan Harris-Reid <aharrisr...@googlemail.com> wrote: > Hi, > > I have a SQLite cursor which I want to traverse more than once, eg... > for row in MyCursor: > method1(row) > then later... > for row in MyCursor: > method2(row) > Method2 is never run, I guess because the pointer is at the bottom of the > row 'stack' after the first 'for' loop > > How can I move the pointer back to the top of the stack? Or do I have to > reload the cursor first?
Either reload the cursor or use fetchall() to get the results into a list and iterate the list. rows = MyCursor.fetchall() for row in rows; ... Kent _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
