Kent Johnson wrote:
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
Thanks for the reply Kent. I used fetchall() to get the results into a list and everything works fine now.

Regards,
Alan

_______________________________________________
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor

Reply via email to