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