Hello all, look at the "Peers HowTo": http://db.apache.org/torque/peers-howto.html
--snip-- This is an example of a complex SQL query and the code you should use to create it: select * from abc where (a < 1 and b > 2) or (a > 5 and b < 3) Criteria crit = new Criteria(); Criteria.Criterion a1 = crit.getNewCriterion(ABC.A, 1, Criteria.LESS_THAN); Criteria.Criterion b2 = crit.getNewCriterion(ABC.B, 2, Criteria.GREATER_THAN); Criteria.Criterion a5 = crit.getNewCriterion(ABC.A, 5, Criteria.GREATER_THAN); Criteria.Criterion b3 = crit.getNewCriterion(ABC.B, 3, Criteria.LESS_THAN); crit.add(a1.and(b2).or(a5.and(b3))); --snip-- HTH, Daniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
