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
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
