> From: Jeffrey Gehrung <[EMAIL PROTECTED]> > > I have (spent much time) reviewing the doSelectJoinTwo(), > doSelectJoinThree() > and doSelectJoinFour() auto-generated in BaseOnePeer but have not been able > figure out how to call or merge these methods so as to join all four tables > to > yeild a single result set from which I can retrieve individual columns from > each of the four tables. (I would like to pass the results to a Velocity > #foreach).
You should find that there is are some protected method named doSelectAllExcept*() in BaseOnePeer that you can either expose by overriding them with a public method on OnePeer, or you can use them as a model for a doSelectAll(). HTH, Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
