On 8/2/06 11:51 PM, Jonathan Vanasco wrote: > b) make a manager sub on stored_information__name that uses a join > against stored_information, but does not retrieve the info in it
Since you always have to fetch something from the "main" (t1) table when using get_objects(), this is the one you want. With this technique, you fetch everything from stored_information__name but nothing from stored_information. Check out the "fetch_only" and "distinct" parameters to get_objects() http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/Manager.pm#dis tinct http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/Manager.pm#fet ch_only The fetch_only parameter is probably your best bet. Try passing a reference to an empty array or one just containing the value "t1". The "distinct" parameter will actually add a DISTINCT keyword to the query, which is probably not what you want in this case. The resulting objects returned should be the same as the above, however. (In both cases, you still have to use require_objects => ... to perform the JOIN itself.) -John ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
