[sqlalchemy] Re: Using order_by in an association many-to-many relationship with columns from the association object

2006-10-29 Thread Michael Bayer
I thought for a while that what you were doing couldnt work right now. this is because a join to the KeywordAssociation object doesnt know anything about the next join to Keyword. but then actually, i realized you could do it, but it does require that the relation from keywordassociation to keywo

[sqlalchemy] Using order_by in an association many-to-many relationship with columns from the association object

2006-10-29 Thread Raul Garcia
Greetings list, I've trying to order a property which is a many-to-many relationship with an association object, with columns that belong not to the relationship table but to the associated one. I think it's better to explain with an example, using the tables of the docs: items = Table('items',