db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ludwig Magnusson" <lud...@itcatapult.com>
Subject RE: Criteria.or not working?
Date Fri, 05 Feb 2010 13:31:35 GMT
Yes that works, but that was not what I asked.
My question was, how can the methods and(), add() and or() all generate the
same result?

-----Original Message-----
From: Ivano Luberti [mailto:luberti@archicoop.it] 
Sent: den 5 februari 2010 14:10
To: Apache Torque Users List
Subject: Re: Criteria.or not working?

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


---------------------------------------------------------------------
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