Hi!
I have a pair of classes that have RelatedJoin columns and I wanted to
retrieve records of one of these that had one specific "attribute" from the
other class. Something like:
================================================================================
class ClassOne(SQLObject)
attribute1 = UnicodeCol()
others = RelatedJoin("ClassTwo", intermediateTable="classone_classtwo",
joinColumn="classone_id", otherColumn="classtwo_id")
class ClassTwo(SQLObject)
attribute2 = UnicodeCol()
things = RelatedJoin("ClassOne", intermediateTable="classone_classtwo",
joinColumn="classtwo_id", otherColumn="classone_id")
================================================================================
How can I get all objects from ClassOne that are associated with ClassTwo.id==3?
I could loop over all records and check their "ClassOne.others" property, but
this is not feasible for a huge table...
I usually do this by hand, but I wanted giving RelatedJoin a try :-)
Thanks for any hints,
--
Jorge Godoy <[EMAIL PROTECTED]>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
