db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon" <eff4...@hotmail.com>
Subject Re: Criteria: several columns OR-combined??
Date Sun, 06 Mar 2005 19:05:00 GMT
If I remember correctly you can and two Criteria objects can't you?  Sorry I 
don't have the source in front of me, it's on my laptop and it takes forever 
to boot up, but I think you might be able to accomplish this by creating two 
Criterias.  The first will have just your COL_1='xxx' and the second will 
consist of COL_2='bla' || COL_3='blu'    Then you should be able to AND 
those two Criteria objects together and get a result criteria from you can 
select on.  I might just be dead wrong, but I suppose it's worth a shot.  ;) 
Good luck.

-Brandon


----- Original Message ----- 
From: "Michael Schmitt" <mi.schmitt@gmx.de>
To: <torque-user@db.apache.org>
Sent: Sunday, March 06, 2005 8:48 AM
Subject: Criteria: several columns OR-combined??


> Hi,
>
> I'm trying to create something like
> SELECT * FROM table_a WHERE table_a.col_1='xxx' AND (table_a.col_2='bla' 
> OR
> table_a.col_3='blu')
> with the Criteria class.
>
> I tried something like this:
>
> Criteria c = new Criteria();
> c.add(TableAPeer.COL_1, 'xxx');
> c.or(TableAPeer.COL_2, 'bla');
> c.or(TableAPeer.COL_3, 'blu');
> TableAPeer.doSelect(c);
>
> but (of course) the  Method or() relates the given criterion to an 
> existing
> criterion for the same column.
> For example, something like
> ...
> c.add(TableAPeer.COL_1, 'xxx');
> c.or(TableAPeer.COL_1, 'yyy');
> ...
> will probably (not tested) result in
> ... WHERE ... AND (table_a.col_1='xxx' OR table_a.col_1='yyy') ...
>
> I thought that I could do something like
> 1. create a new criterion
> 2. pass the (table_a.col_2='bla' OR table_a.col_3='blu') to the criterion
> 3. add the criterion to the criteria
> but as far as I understand, a criterion always relates to a single column.
>
> any ideas?
>
> greetings,
> michael
>
>
> ---------------------------------------------------------------------
> 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