I have a search to do over different tables. One of this tables is in a many to many relationship with another table. SqlObject handle this many to many relation with a ForeignKey. I don't wan't to use the generated middle table directly, since SqlObject can handle it differently in different version, and the software is used at different places, running different databases system, etc. So I can't really use a select, since I would have to specify the many-to-many middle table in the clauseTable argument, and I can't use JOIN, for the same reason.
Would there be a way around making an algorithm that retrieve every field in the many to many relationship for each item in the "primary" table without using a firm table name for the many to many table. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. 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
