On Jan 25, 2006, at 2:37 AM, Oleg Broytmann wrote:
You have to add all straight joins yourself:
AND(..., Staff.q.id == StaffSubject.q.staffID,
StaffSubject.q.subjectID == Subject.q.id...)
(just an example...)
Thanks Oleg. Since I'm defining all of the relationships between
tables in my classes by including lots of RelatedJoins and
MultipleJoins, it would be cool if SQLObject could infer what
straight joins are required.
I'm afraid it's still not clear how I address the join tables that
SQLObject creates to handle the many-to-many relationships that exist
in my model. When I try your suggestion I get a NameError because
StaffSubject (for example) is not defined. Do I need to create
classes for those join tables? That wouldn't seem to fit with what
I've read in the docs.
-Tim
--
Timothy Wilson
Technology Integration Specialist
Apple Distinguished Educator
Hopkins ISD #270, Hopkins, MN, USA
ph: 952.988.4103 fax: 952.988.4311 blog: http://technosavvy.org
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
