Re: [Sqlalchemy-users] 1 table with many columns referencing another

2006-03-28 Thread alanp
And that after I even RTFMed the advanced datamapping section of the docs. Sorry for displaying my stupidity in public :-\ Thanks for the great software BTW: an ORM that does things The Right Way (tm) :-) On 29 Mar 2006, at 12:04 AM, Michael Bayer wrote: you must specify explicit jo

Re: [Sqlalchemy-users] 1 table with many columns referencing another

2006-03-28 Thread Michael Bayer
you must specify explicit join conditions on your relations as in: http://www.sqlalchemy.org/docs/adv_datamapping.myt#adv_datamapping_relations_customjoin and the example similar to what youre doing is: http://www.sqlalchemy.org/docs/adv_datamapping.myt#adv_datamapping_relations_multiplejoin

[Sqlalchemy-users] 1 table with many columns referencing another

2006-03-28 Thread alanp
Hi all, Excuse the long post: I hope the extra info (code, SA logging info, db queries) helps illustrate my problem. BTW I'm using SQLAlchemy 0.1.4). BTW2: I haven't examined the SA code yet to see what I'm doing wrong: I'm hoping some-one can point out my stupidity before I spend too much t