[sqlalchemy] Re: order_by on related object attribute?

2007-04-20 Thread Gaetan de Menten
On 4/19/07, Michael Bayer [EMAIL PROTECTED] wrote: On Apr 19, 2007, at 9:39 AM, Gaetan de Menten wrote: By the way, lately I've been wishing SQLAlchemy would add a column (and possibly its table) automatically to the select clause if I do an order by a column which is not in the

[sqlalchemy] Re: order_by on related object attribute?

2007-04-18 Thread Michael Bayer
On Apr 18, 2007, at 12:21 AM, Chris Shenton wrote: I'm using SQLAlchemy with Pylons and query my 'system' table and order by their client_id field like: from er.models import System, Vendor, Client sys = self.session.query(System).select(System.c.lastseen self.this_week,