On 12/11/12 08:29, Khalid Al-Ghamdi wrote:
Hi all,
How would you go about adding items from a cursor to a dictionary?
i tried this but to no avail:
>>> cur.execute('select * from schedule limit 10')
<sqlite3.Cursor object at 0x0112CE60>
>>> for i in range(len(cur.fetchall())):
d[i]=cur.fetchall()[i]
The second fetchall() won't return anything because you already fetched
all there was to fetch in the first call.
But why would you want a dictionary indexed by sequence number? You'd be
better off with a list, which is what fetchall() gives you..
The normal pattern would be
for row in cur.fetchall():
d[ row[0] ] = row # assuming row[0] is the desired key
or similar.
--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
