Menu
▾
▴
[Hibernate-commits] Hibernate/doc/reference/html query-language.html,1.20,1.21
|
From: <one...@us...> - 2002-11-19 15:35:38
|
Update of /cvsroot/hibernate/Hibernate/doc/reference/html
In directory sc8-pr-cvs1:/tmp/cvs-serv2395/doc/reference/html
Modified Files:
query-language.html
Log Message:
allow not between, not in in query language
allow subqueries beginning with a from clause in query language
Index: query-language.html
===================================================================
RCS file: /cvsroot/hibernate/Hibernate/doc/reference/html/query-language.html,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** query-language.html 28 Oct 2002 15:41:54 -0000 1.20
--- query-language.html 19 Nov 2002 15:35:35 -0000 1.21
***************
*** 152,169 ****
Java <tt>public static final</tt> constants <tt>eg.Color.TABBY</tt>
</p></li></ul></div><p>
! <tt>in</tt> and <tt>between</tt>
! may be used as follows:
</p><pre class="programlisting">from cat in class eg.DomesticCat where cat.name between 'A' and 'B'
from cat in class eg.DomesticCat where cat.name in ( 'Foo', 'Bar', Baz" )</pre><p>
! but the negated forms should be written
! </p><pre class="programlisting">from cat in class eg.DomesticCat where not cat.name between 'A' and 'B'
!
! from cat in class eg.DomesticCat where not cat.name in ( 'Foo', 'Bar', Baz" )</pre><p>
! rather than
! </p><pre class="programlisting">from cat in class eg.DomesticCat where cat.name not between 'A' and 'B' (Error)
! from cat in class eg.DomesticCat where cat.name not in ( 'Foo', 'Bar', Baz" ) (Error)</pre><p>
! However, both <tt>is null</tt> and <tt>is not null</tt> may be used to test
for null values.
</p><p>
--- 152,164 ----
Java <tt>public static final</tt> constants <tt>eg.Color.TABBY</tt>
</p></li></ul></div><p>
! <tt>in</tt> and <tt>between</tt> may be used as follows:
</p><pre class="programlisting">from cat in class eg.DomesticCat where cat.name between 'A' and 'B'
from cat in class eg.DomesticCat where cat.name in ( 'Foo', 'Bar', Baz" )</pre><p>
! and the negated forms may be written
! </p><pre class="programlisting">from cat in class eg.DomesticCat where cat.name not between 'A' and 'B'
! from cat in class eg.DomesticCat where cat.name not in ( 'Foo', 'Bar', Baz" )</pre><p>
! Likewise, <tt>is null</tt> and <tt>is not null</tt> may be used to test
for null values.
</p><p>
***************
*** 266,268 ****
from cat in class eg.DomesticCat where cat.name =
! some( select list.name from list in class eg.NameList )</pre></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="manipulating-data.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="index.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="transactions.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 6. Manipulating Persistent Data </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 8. Transactions And Concurrency</td></tr></table></div></body></html>
\ No newline at end of file
--- 261,266 ----
from cat in class eg.DomesticCat where cat.name =
! some( select list.name from list in class eg.NameList )
!
! from cat in class eg.Cat where not exists
! ( from mate in class eg.Cat where mate.mate = cat )</pre></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="manipulating-data.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="index.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="transactions.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 6. Manipulating Persistent Data </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 8. Transactions And Concurrency</td></tr></table></div></body></html>
\ No newline at end of file
|
