Re: [sqlalchemy] Re: sqla 0.6.4, orm, problem with self-referring joins

2010-09-21 Thread Michael Bayer
On Sep 20, 2010, at 9:31 PM, Michael Bayer wrote: > > On Sep 20, 2010, at 6:44 PM, me wrote: > >> thanks for the help. it probably makes sense to alias the on-clause to >> the query then, i just wasn't thinking in that way for some reason. >> >>> So here you want to first call reset_joinpoint(

Re: [sqlalchemy] Re: sqla 0.6.4, orm, problem with self-referring joins

2010-09-20 Thread Michael Bayer
On Sep 20, 2010, at 6:44 PM, me wrote: > thanks for the help. it probably makes sense to alias the on-clause to > the query then, i just wasn't thinking in that way for some reason. > >> So here you want to first call reset_joinpoint() before calling join() again. > > tried this and got the sam

[sqlalchemy] Re: sqla 0.6.4, orm, problem with self-referring joins

2010-09-20 Thread me
thanks for the help. it probably makes sense to alias the on-clause to the query then, i just wasn't thinking in that way for some reason. > So here you want to first call reset_joinpoint() before calling join() again. tried this and got the same result (doesn't join/outerjoin reset the join poin