On Jun 11, 2007, at 11:19 AM, Glauco wrote:
> I use hardly the column prefix, so my query are always aliased.....
> this obviously cause a lot of problem whith the order_by clause
> (that NOT use the same aliases)
>
the approach here depends on how this query is being constructed. if
you are using your own alias objects, insert the columns as
referenced from the alias object itself into the order_by clause.
alias = mytable.alias('foo')
alias.select(order_by=[alias.c.bar])
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---