Thanks! That worked.
-----Original Message----- From: Bill Leng [mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 5:00 PM To: Apache Torque Users List Subject: Re: Force OR statement? try something like this. Criteria c = new Criteria(); Criteria.Criterion fromCat = c.getNewCriterion( IxConnectionPeer.FROM_CATEGORY, category, Criteria.EQUAL); Criteria.Criterion toCat = c.getNewCriterion( IxConnectionPeer.TO_CATEGORY, category, Criteria.EQUAL); c.add(fromCat.or(toCat)); Aaron Loucks wrote: >According to the API Docs : > > >or > >public Criteria ><http://db.apache.org/torque/apidocs/org/apache/torque/util/Criteria.html> >or(java.lang.String column, > java.lang.Object value, > SqlEnum ><http://db.apache.org/torque/apidocs/org/apache/torque/util/SqlEnum.html> >comparison) > >This method adds a new criterion to the list of criterias. If a criterion >for the requested column already exists, it is "OR"ed to the existing >criterion. If is used as follow: > > > >Is there any way for force the Criteria to be OR'ed? For example I'm trying >to do something like the following: > > > > > >SELECT * FROM table WHERE first_name LIKE '%queryString%' OR last_name LIKE >'%queryString%'; > > > >When I create the criteria by doing something like the following, it always >creates the statement with AND's rather than an OR. According to the >documentation this is correct, but this isn't the output I'm looking for. Is >there something in the API that I over looked? Or is this not possible? > > > >Criteria c = new Criteria(); > >String queryString = "joe"; > > > >c.add(TablePeer.FIRST_NAME, (Object)("%" + queryString + "%"), >Criteria.LIKE); > >c.or(TablePeer.LAST_NAME, (Object)("%" + queryString + "%"), Criteria.LIKE); > > > > > >- Aaron > > > > > > -- Bill Leng Sr. Software Engineer Metatomix, Inc. Tel: (901)261-8911 Fax: (901)261-8901 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
