Marc,
Try using Criterions, i.e.:
Criteria crit = new Criteria();
Criteria.Criterion fielda = crit.getNewCriterion(TABLE.fielda, new int[]{0,
11}, Criteria.IN);
Criteria.Criterion fieldb = crit.getNewCriterion(TABLE.fieldb, xxx,
Criteria.EQUAL);
crit.add(fielda.and(fieldb));
Regards,
Tom
-----Original Message-----
From: Marc Lustig [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 4:54 AM
To: Torque Users List
Subject: criteria-problem with or/and
Hi,
can somebody give me a hint how to use criteria to build a WHERE-clause that
looks like this:
WHERE (fielda=0 or fielda=11) and fieldb=xxx
I looked into the various or() methods, but still not sure how to use it.
Thanks.
Marc
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
