Antonio, wrt to your concerns, I have just posted a patch as part of bug 1221 (http://bugzilla.exolab.org/show_bug.cgi?id=1221) that introduces LIIMT and OFFSET clauses to Castor's OQL syntax. I still have to amend existing documentation, but feel free to test the added functionality and come back to me with comments.
Regards Werner On Mon, 26 Jul 2004 17:40:07 +0200, Antonio Capani wrote: >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
