db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dressler, Erik(externe MA)" <Erik.Dress...@Dresdner-Bank.lu>
Subject RE: torque and subqueries
Date Mon, 09 May 2005 15:55:51 GMT

i worried about the answer! ok, i'll make it step by step!

thx a lot, thomas

> -----Original Message-----
> From:	Thomas Fischer [SMTP:fischer@seitenbau.net]
> Sent:	09 May 2005 17:35
> To:	Apache Torque Users List
> Subject:	RE: torque and subqueries
> 
> 
> 
> 
> 
> Hi,
> 
> To my knowledge, it is not possible to create subqueries via criteria. You
> have to create the query by hand and use e.g.
> BasePeer.doSelectVillageRecords() to execute it.
> Alternatively, if it is not too much overhead, you can also compose the
> subquery, execute it to get the results, and build a new criteria from it.
> Another possibility might be the following: Perhaps your query is such
> that
> it is possible to use a view for it. Then, in the schema.xml, you have to
> insert a table which corresponds to the view, and only read from it. For
> this, you would have to edit the db create sql script by hand.
> 
>     Thomas
> 
> "Dressler, Erik(externe MA)" <Erik.Dressler@Dresdner-Bank.lu> schrieb am
> 09.05.2005 15:56:16:
> 
> >
> > hi, folks!
> >
> > is it possible, to map subqueries with torque? if the answer is yes,
> please
> > tell me how!!! :D
> >
> > greetz, erik dressler
> >
> > *  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
> >
> > This message is confidential and intended for the named addressee(s)
> only.
> > If you are not the intended recipient, please contact the sender by
> E-Mail
> > return and then delete this message from your system. You should not
> copy
> > or use it or disclose its contents to any other person.
> >
> > If any part of this message is illegible or if you suspect that the
> message
> > may have been intercepted or amended, please contact the sender.
> > Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
> > accuracy or completeness of this message without further investigation.
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
 
*  *  *  *  *  *  D I S C L A I M E R  *  *  *  *  *  *  *
 
This message is confidential and intended for the named addressee(s) only.
If you are not the intended recipient, please contact the sender by E-Mail
return and then delete this message from your system. You should not copy
or use it or disclose its contents to any other person.
 
If any part of this message is illegible or if you suspect that the message
may have been intercepted or amended, please contact the sender.
Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the
accuracy or completeness of this message without further investigation.
 


---------------------------------------------------------------------
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