You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Bill <bh...@collaborativefusion.com> on 2003/01/22 16:09:18 UTC

Criteria help

I'm having trouble making a select work using Peers and Criteria. My
code looks something like this:

Criteria crit = new Criteria();

crit.addSelectColumn(FooPeer.FOOID);

// COLUMN2 is of type String
crit.add(Foo.COLUMN2, (Object) searchstring, Criteria.LIKE);
crit.or(Foo.COLUMN3, (Object) searchstring, Criteria.LIKE);

This produces:

select FOOID from foo where COLUMN2 LIKE 'searchstring' AND COLUMN3 LIKE
'searchstring';

what I want is:

select FOOID from foo where COLUMN2 LIKE 'searchstring' OR COLUMN3 LIKE
'searchstring';

What is it I'm missing here? 

thanks

-b


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Criteria help

Posted by Akmal Sarhan <as...@byteaction.de>.
IIRC this only works with Criterion:

 Criteria crit=new Criteria();
 Criteria.Criterion criterion = crit.getNewCriterion(Foo.COLUMN2, (Object)
searchstring, Criteria.LIKE);
 criterion.or(crit.getNewCriterion(Foo.COLUMN1, (Object) searchstring,
Criteria.LIKE));
 crit.add(criterion);

regards
Akmal
----- Original Message -----
From: "Bill" <bh...@collaborativefusion.com>
To: "turbine-user" <tu...@jakarta.apache.org>
Sent: Wednesday, January 22, 2003 4:09 PM
Subject: Criteria help


> I'm having trouble making a select work using Peers and Criteria. My
> code looks something like this:
>
> Criteria crit = new Criteria();
>
> crit.addSelectColumn(FooPeer.FOOID);
>
> // COLUMN2 is of type String
> crit.add(Foo.COLUMN2, (Object) searchstring, Criteria.LIKE);
> crit.or(Foo.COLUMN3, (Object) searchstring, Criteria.LIKE);
>
> This produces:
>
> select FOOID from foo where COLUMN2 LIKE 'searchstring' AND COLUMN3 LIKE
> 'searchstring';
>
> what I want is:
>
> select FOOID from foo where COLUMN2 LIKE 'searchstring' OR COLUMN3 LIKE
> 'searchstring';
>
> What is it I'm missing here?
>
> thanks
>
> -b
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>