If you want to combine clauses mixinn and and or operators you should use Criterion.
Look here for an introduction to how build queries using Criteria and Criterion http://db.apache.org/torque/releases/torque-3.3/runtime/reference/read-from-db.html Ludwig Magnusson ha scritto: > Hi! > > I have done some testing during development of a project here and it seems > that criteria.and([parameters]), criteria.add([parameters]) and > criteria.or([parameters]) all generate the same query to the database. > > > > E.g these three code snippets: > > Criteria criteria = new Criteria(); > > criteria.and("user.first_name", "John"); > > criteria.and("user.last_name", "Doe"); > > UserPeer.doSelect(criteria); > > > > Criteria criteria = new Criteria(); > > criteria.add("user.first_name", "John"); > > criteria.add("user.last_name", "Doe"); > > UserPeer.doSelect(criteria); > > > > Criteria criteria = new Criteria(); > > criteria.or("user.first_name", "John"); > > criteria.or("user.last_name", "Doe"); > > UserPeer.doSelect(criteria); > > > > . would all generate the Sql query > > SELECT * FROM USER WHERE first_name = "John" AND last_name = "Doe"; > > > > How can this be? > > /Ludwig > > > -- ================================================== dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it ================================================== --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org
