Antonio, I didn't want to imply that I want you to apply this patch against any set of sources. If you felt like trying out the new functionality, I'd recommend you'd download the latest sources from CVS, build the JARs yourself and give it a go. Alternatively, I think you could download a daily snapshot from ftp://ftp.exolab.org/pub/castor/castor_daily_snapshot.tgz and build the binaries yourself. This is especially useful if you happen to be behind a corporate firewall, and hence cannot access a CVS repository.
Thanks Werner On Wed, 11 Aug 2004 17:40:59 +0200, Antonio Capani wrote: >Dear Werner, > >where have I to apply the patch? To the 0.9.5.3 sources? > >How can I apply the patch? I have saved it in a file and I have downloaded >the "patch" program from Cygwin, but I do not know which commandline params >to use in order to apply your patch. > >Thank you for your help. > >Antonio > >At 12.09 11/08/2004, you wrote: > > >>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 > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-user
