Re: Unpacking of query result

2006-04-30 Thread DarkBlue
Thank you Mission accomplished. Have a nice sunday Db -- http://mail.python.org/mailman/listinfo/python-list

Re: Unpacking of query result

2006-04-30 Thread Fredrik Lundh
"DarkBlue" <[EMAIL PROTECTED]> wrote: > 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 (w

Re: Unpacking of query result

2006-04-30 Thread DarkBlue
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) i