Hi, I have a class User and I want to have a friends relation ship between users in that table. Is it possible to do it like in the snippet bellow. Is there a better way to do it with SQLObject?
I have tested this. and it works, but this construction doesn't fee right to me. Also the problems is that I have to do two add, u1.addUser(u2), u2.addUser(u1) to have the complete relation. Maybe whit a different construction I can do it in one operation. class User(SQLObject): user_name = UnicodeCol(length=16, alternateID=True) display_name = UnicodeCol(length=255) ... friends = RelatedJoin('User', intermediateTable='user_user', joinColumn='user_id', otherColumn='id') Thanks for your suggestions -fred- ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss