You'll probably have to use the Criteria object for this , there's a good
example on the Turbine site.
/Colin
----- Original Message -----
From: "Andrea Papotti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 3:32 PM
Subject: Another Criteria Help
> Hi, I'm here again...
>
> I have found no hint in the Turbine docs about this:
>
> How can I use Criteria to obtain a query like this
>
> Select A,B,C from TABLE where A='10' and (B='0' or C='0')
>
> I'm able to obtain only this query:
>
> Select A,B,C from TABLE where A='10' and B='0' or C='0'
>
> using:
>
> ...
> Criteria criteria = new Criteria();
> criteria.add(TablePeer.A,"10");
> criteria.add(TablePeer.B,"0");
> criteria.or(TablePeer.C,"0");
> ...
>
> but this gets also records whith A!='10' but C='0'
>
> more generally, how can you use braces with Criteria
>
> TVMIA, Andrea
>
>
> ---------------------------------------------------------------------
> 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]
