On 9/27/07, Glauco <[EMAIL PROTECTED]> wrote:
> If so, I think I know what you are doing wrong... you must use Query's
> .join() or .outerjoin() method. Like that:
>
> session.query(ObjectA).join('property_b').order_by(ObjectB.c.foobar)
>
> Where 'foobar' maps to the column from B table which you want to use
> to sort your data...
>
>
> This is correct Roger, but my problem is when in this example SA compile
> the qry using alias
>
> select ... form table_a as alias1..... table_b as alias2....... order by
> table_a.column1
>
>
> in this case the qry is wrong because the order by is incorrect.
>
> take a look
>
> <SNIP>
Glauco, can you send a small test script reproducing the error ?
I'll gladly take a look at that...
Cheers,
Roger
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
