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" <[EMAIL PROTECTED]> To: "turbine-user" <[EMAIL PROTECTED]> 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: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
