db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thoralf Rickert" <thoralf.rick...@cadooz.de>
Subject AW: Problems to set up a subquery
Date Fri, 20 Oct 2006 09:23:56 GMT

> Sort of a "clean" approach, but not working due sql exections:
> [...]
> 	criteria.addNotIn(KundenadressePeer.KUNDENADRESS_ID, 
> AdressenreferenzPeer.doSelect(subCriteria));
> [...]

Just a question because I'm not sure if you just show an example or the
real code, that you're using. The doSelect() method in your addNotIn()
returns a list of Adressreferenz objects. If you put this into a
addNotIn - I think the query-generation-process uses the String
representation of these Adressreferenz objects to create the sql-query.
Did you overwrite the toString() method in Adressreferenz? I'm not sure,
if you have to do this, but my Torque version (3.2) uses toString() to
create the query. The generated toString() method in BaseAdressreferenz
is nice for debugging but useless for sql-queries, I think.

bye
Thoralf


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message