Unpacking of query result

DarkBlue nomail at nixmail.com
Sun Apr 30 04:30:00 EDT 2006


Hello

Following part of an database query works fine :

self.cur=con1.cursor
self.cur.execute('select a,b,c,d from t1')
for (a,b,c,d) in self.cur:
    print a,b,c,d


but how to do this:

self.cur.execute(sql_select_text_put_in_at_runtime)
for (whatever_was_in_the_select_text_part_of_the_query) in self.cur:
    print 'returned result set'

Will it be necessary to parse the sql string and find any possible
return columns or is there a better way so that the query can be used
generically , that is without knowing at coding time
what or how many columns will be returned ?


Thanks
Db







More information about the Python-list mailing list