[sqlalchemy] Re: returning values as a list of values rather than as list of tuples

2009-01-15 Thread Matthew Zwier
Hi Faheem, On Thu, Jan 15, 2009 at 11:05 AM, Faheem Mitha fah...@email.unc.edu wrote: Hi, The following code returns a list of tuples to python from the db, corresponding to the values of the 'snpval_id' column in the table 'cell'. I was wondering if there was an easy way to have it

[sqlalchemy] Re: returning values as a list of values rather than as list of tuples

2009-01-15 Thread Faheem Mitha
On Thu, 15 Jan 2009, Matthew Zwier wrote: Hi Faheem, On Thu, Jan 15, 2009 at 11:05 AM, Faheem Mitha fah...@email.unc.edu wrote: Hi, The following code returns a list of tuples to python from the db, corresponding to the values of the 'snpval_id' column in the table 'cell'. I was

[sqlalchemy] Re: returning values as a list of values rather than as list of tuples

2009-01-15 Thread Eric Ongerth
I've always thought this format for the list comprehension was particularly clean: result = [x for (x, ) in conn.execute(.).fetchall()] On Jan 15, 8:27 am, Faheem Mitha fah...@email.unc.edu wrote: On Thu, 15 Jan 2009, Matthew Zwier wrote: Hi Faheem, On Thu, Jan 15, 2009 at 11:05 AM,