db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From b..@apache.org
Subject cvs commit: db-ojb/xdocs query.xml
Date Sun, 14 Dec 2003 11:16:13 GMT
brj         2003/12/14 03:16:13

  Modified:    xdocs    query.xml
  Log:
  added negating a criteria
  
  Revision  Changes    Path
  1.25      +22 -0     db-ojb/xdocs/query.xml
  
  Index: query.xml
  ===================================================================
  RCS file: /home/cvs/db-ojb/xdocs/query.xml,v
  retrieving revision 1.24
  retrieving revision 1.25
  diff -u -r1.24 -r1.25
  --- query.xml	8 Dec 2003 17:46:14 -0000	1.24
  +++ query.xml	14 Dec 2003 11:16:13 -0000	1.25
  @@ -170,6 +170,28 @@
   </p>
   </subsection>
   
  +<subsection name="negating the criteria">
  +<p>
  +A criteria can be negated to obtain <b>NOT</b> in the WHERE-clause:
  +
  +<source><![CDATA[
  +Criteria crit1 = new Criteria();
  +crit1.addLike("firstname", "%o%");
  +crit1.addLike("lastname", "%m%");
  +crit1.setNegative(true);
  +
  +Collection results = broker.getCollectionByQuery(q);
  +]]></source>
  +
  +<br/>
  +This query will generate an SQL statement like this:
  +
  +<source><![CDATA[
  +SELECT ... WHERE NOT (FIRSTNAME LIKE "%o%" AND LASTNAME LIKE "%m%")
  +]]></source>
  +
  +</p>
  +</subsection>
   </subsection>
   
   <subsection name="ordering and grouping">
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message