[sqlalchemy] Re: group_by and column labels

2007-06-08 Thread Huy Do
Michael Bayer wrote: On Jun 7, 2007, at 7:17 AM, Huy Do wrote: Michael Bayer wrote: put strings into group_by: group_by = [client_code, client_name, ...] Hi Michael, Sorry I'm not sure what you are suggesting. I don't really want to retype my column names again in the

[sqlalchemy] Re: group_by and column labels

2007-06-08 Thread Huy Do
Hi Rick, If this works, that is fine for me. I just don't want to retype my columns to avoid errors. I'll test and then send an update. Thanks Huy I think the .name property of a labled column holds the label, so how about db.job_table, db.client_table, db.service_type_table],

[sqlalchemy] Re: group_by and column labels

2007-06-08 Thread Huy Do
I think the .name property of a labled column holds the label, so how about db.job_table, db.client_table, db.service_type_table], group_by = [col.name http://col.name for col in group_by], This almost worked, but not quite. Using the name column, does give me the

[sqlalchemy] Re: group_by and column labels

2007-06-07 Thread Huy Do
Michael Bayer wrote: put strings into group_by: group_by = [client_code, client_name, ...] Hi Michael, Sorry I'm not sure what you are suggesting. I don't really want to retype my column names again in the group_by clause. My intention was to be able to reuse the actual column list in