Re: Fastest way to convert sql result into a dict or list ?

2008-10-30 Thread Peter Otten
Dennis Lee Bieber wrote: > On Wed, 29 Oct 2008 04:35:31 -0700 (PDT), "[EMAIL PROTECTED]" > <[EMAIL PROTECTED]> declaimed the following in comp.lang.python: > >> Hello, >> >> I'm trying to find the fastest way to convert an sql result into a >> dict or list. >> What i mean, for example: >> my sql

Re: Fastest way to convert sql result into a dict or list ?

2008-10-29 Thread Steve Holden
[EMAIL PROTECTED] wrote: > Hello, > > I'm trying to find the fastest way to convert an sql result into a > dict or list. > What i mean, for example: > my sql result: > contact_id, field_id, field_name, value > sql_result=[[1, 1, 'address', 'something street'], > [1, 2, 'telnumber'

Re: Fastest way to convert sql result into a dict or list ?

2008-10-29 Thread alex23
On Oct 29, 9:35 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I'm trying to find the fastest way to convert an sql result into a > dict or list. >>> from collections import defaultdict >>> results = defaultdict(defaultdict) >>> for contact_id, field_id, field_name, value in sql_

Re: Fastest way to convert sql result into a dict or list ?

2008-10-29 Thread Peter Otten
[EMAIL PROTECTED] wrote: > Hello, > > I'm trying to find the fastest way to convert an sql result into a > dict or list. > What i mean, for example: > my sql result: > contact_id, field_id, field_name, value > sql_result=[[1, 1, 'address', 'something street'], > [1, 2, 'telnumber

Fastest way to convert sql result into a dict or list ?

2008-10-29 Thread [EMAIL PROTECTED]
Hello, I'm trying to find the fastest way to convert an sql result into a dict or list. What i mean, for example: my sql result: contact_id, field_id, field_name, value sql_result=[[1, 1, 'address', 'something street'], [1, 2, 'telnumber', '11'], [1, 3, 'e