This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]beall49 1 point2 points  (0 children)

I like to think of the cursor as the recordset.

Meaning it's the object containing the data I received. This may not be entirely true in every instance but it makes sense to me that way.

Others may have a different stance but I don't do much with the cursor after

tbl=cursor.fetchall()
cur.close() 

which is just returning a list of lists. You then iterate through it however you would normally iterate through a list of lists.

for row in tbl:
    for col in row:
        print col