Python SQLite Return Value

Question

I am trying to return a numeric value from this statement:

c = db.execute("""SELECT *, rowid FROM members WHERE barcode = '%s' AND debit > 0 LIMIT 50""" % (s,))

But I get this as the returned value:

sqlite3.Cursor object at 0xb6cb2720

What should I do with this cursor object to get the results?

Answer 1

Try this:

for row in c:
    print row['rowid']