Hi Graham, Subselects are not covered by Criteria directly. So you have to use handcoded SQL. You can: 1. to use Criteria.addSQL() 2. to use QueryBySql to run arbitrary select statements.
cheers, Thomas Graham Lounder wrote: > Hey All, > > Is it possible to use nested selects? What is the best approach to > do this? In my last project I looped through results of one query, > executing other queries. Is there a better way of doing this? Is > there features in OJB that will do this for me? I was thinking of > using the Criteria.addSQL() and add my own nested select code. > > Any Ideas? Graham > > ============================================ Graham Lounder Java > Developer Spatial Components Division CARIS 264 Rookwood Ave > Fredericton NB E3B-2M2 Office 506 462-4263 Fax 506 459-3849 > [EMAIL PROTECTED] http://www.spatialcomponents.com > ============================================ > > > -- To unsubscribe, e-mail: > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional > commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
