Thank you, that helped a lot.
I would suggest to the developers to document the LIMIT/OFFSET syntax in the OQL documentation
http://castor.exolab.org/oql.html
Antonio
At 17.22 26/07/2004, you wrote:
content-class: urn:content-classes:message Content-Type: text/plain; x-avg-checked=avg-ok-32787A3E; charset=us-ascii
Hi,
Please follow the link below. This link has information on the syntax of "Limit clause" for various DB vendors. http://brainopolis.dnsalias.com/castorwiki/Wiki.jsp?page=OQLLimit
-Banujee
Antonio Capani wrote:
> Hi,
> I wonder if it is possible to limit the results of a selection done by
> e > selection query. > I am looking for something like:
> select x from mytable x where x.id > 3 limit 10 skip 20
> this should return no more than 10 results after skipping the first 20 > results > This feature would help to implement cursors.
> I have not found a solution to this problem in the documentation.
Antonio,
Castor currently provides support for the LIMIT clause for MySQL,
PostgreSQL and SQL Server. However, there are no samples of the use of
each implementation. I suggest searching the mailing list archives
available here:
http://www.castor.org/lists.html
Bruce --
perl -e 'print
unpack("u30","<0G)[EMAIL PROTECTED]&5R\\"F9E<G)E=\\$\\!F<FEI+F-O;0\\`\\`");'
The Castor Project http://www.castor.org/
Apache Geronimo http://incubator.apache.org/projects/geronimo.html
-----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 4:33 PM To: [EMAIL PROTECTED] Subject: Re: [castor-user] oql: how to limit the number of the results? -----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-user
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-user
Antonio Capani nibbles.it srl - do IT better 349.4969744 (cellulare) 010.3453029 (casa/ufficio)
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
