db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivano Luberti <lube...@archicoop.it>
Subject Re: Criteria.or not working?
Date Fri, 05 Feb 2010 13:10:14 GMT
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-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message