Such a method is not generated by the Torque generator, which will only create join methods one foreign-key level away.
You can write your own "doSelectJoinUsersProfiles()" method, however, which sounds like a terrific opportunity to leverage your UserPeer class... ;o) Adam Robert Bowen <[EMAIL PROTECTED]> To: Apache Torque Users List <torque-user@db.apache.org> cc: Subject: Re: How to use doSelectJoin? 03/17/05 12:32 PM Please respond to "Apache Torque Users List" Hello, thanks for the response. Yea, "doSelectJoinXxxx()" is a protected method generated by Torque but in my particular situation, this method is not being generated for the object I need. There is a doSelectJoinProfiles() in the BaseUsersProfilesPeer class, which will load all the info for all profiles associated with any UsersProfiles object, but there is no "doSelectJoinUsersProfiles()" method in my BaseUserPeer class, and this is what I need -- to first load all UsersProfiles associated with a given user, and then load all of the Profiles themselvs (specifically what I need is the profile name). Any other takers? Bob --- Dave Newton <[EMAIL PROTECTED]> wrote: > Robert Bowen wrote: > > >So how can I do the same thing for "user", which > has a > >foreign key TO "users_profiles"? > > > > > Isn't there a protected method in the base user that > does the join? In > the generated javadocs for your OM it should say > something like "this > isn't exposed to keep the API reasonable" or > something like that. > > You need to expose the method in your user class > (the one for > implementing custom functionality) and you should be > all set. > > Dave > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]