David Pratt wrote: > Hi Fredrik. Many thanks for your reply and for the tuple tip. The > cursor.fetchall returns a list of lists in this instance with each list > in the main list containing the field values. With the tip, I > simplified my code to: > > vlist_dict = {} > record_count = 0 > for record in cursor.fetchall(): > record_count += 1 > vlist_dict[record_count] = tuple(record) > print vlist_dict > > That's much better!
I meant to write d = {} for index, record in enumerate(cursor.fetchall()): d[index+1] = tuple(record) which can be shorted to d = dict((k+1, tuple(v)) for k, v in enumerate(x)) in recent versions of Python. </F> -- http://mail.python.org/mailman/listinfo/python-list