Uh, LIMIT and OFFSET are not supported? This may not be standard SQL, but some DBs that Hibernate supports do support that SQL extension. I thought that the whole point of having different Dialects for different types of databases was to support things that are different, non-standard about them. No? Are there any plans to support LIMIT and OFFSET? I know I will be needing it in my application, which will use PostgreSQL. I am already using it in some code that uses straight JDBC, which I was hoping to convert to work with Hibernate.
Thanks, Otis ---- On Sat, 18 Jan 2003, Gavin King ([EMAIL PROTECTED]) wrote: > Note that the Hibernate query language does not support the "limit" > syntax. Use setMaxResults() instead. > > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will > allow you to extend the highest allowed 128 bit encryption to all your > clients even if they use browsers that are limited to 40 bit encryption. > Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag ------------------------------------------------------- This SF.NET email is sponsored by: Thawte.com - A 128-bit supercerts will allow you to extend the highest allowed 128 bit encryption to all your clients even if they use browsers that are limited to 40 bit encryption. Get a guide here:http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0030en _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel