[Tutor] Help with cursors please

[Kent Johnson]

On Thu, Feb 4, 2010 at 12:47 PM, Alan Harris-Reid
<aharrisreid at 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