Hello,
One thing that I have found very useful in complex queries is to bypass the
Criteria objects.
All you have to do is to write the SQL query, execute it using
BasePeer.executeQuery() to get a List of Records and then create a list of
persistent objects using the populateObjects of the corresponding Peer class.
In this case, you can use:
String query = "SELECT DISTINCT * FROM kundenadresse WHERE kundenadress_id
NOT IN (SELECT kundenadress_id FROM adressenreferenz)";
List kundenadresses =
KundenadressePeer.populateObjects(BasePeer.executeQuery(query));
It works fine if you have a query of the form: "select * from foo...", ie you
select all the columns of a single table. I don't have the source code handy to
check if this query would work (my feeling is that this would work also):
String query = "SELECT * FROM FOO f, BAR b WHERE f.b = b.f AND ...";
List list = FooPeer.populateObjects(BasePeer.executeQuery(query));
Enjoy,
Antonis
> Hi,
>
> Subqueries are implemented and documented in the svn version(3.2.1-dev),
> but not in Torque 3.2.0.
> Either build Torque from svn or, if you want to use Torque 3.2.0. you can
> code the subquery as custom criteria (see
> http://db.apache.org/torque/releases/torque-3.2
> /runtime/reference/read-from-db.html#Using_the_CUSTOM_modifier_to_use_custom_SQL)
> (you can also build the subquery via another Criteria and its
> toString()-method if you do not want to hand-code it).
>
> Thomas
>
> "Pfiester, Jan" <[EMAIL PROTECTED]> schrieb am 16.10.2006
> 17:40:05:
>
> > Hi everyone,
> >
> > I ran into problems to setup the following query using criteria:
> >
> > SELECT DISTINCT * FROM kundenadresse
> > WHERE kundenadress_id NOT IN(
> > SELECT kundenadress_id FROM adressenreferenz
> > );
> >
> > Could someone please give me some help to come up with a proper solution?
> > Hints for further reading on this topic would also be very much
> appreciated!
> >
> > Many thanks in advance,
> > Jan
> >
> > ---------------------------------------------------------------------
> > 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]
>
>
--
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
