Hibernate version:
3.0.5

Hibernaters,

I am wondering if there is any way in HQL to select, say, the 51st-100th rows of a query. I am trying to implement what some websites do when they say "click here to see the next 50 results". I'm guessing this can be done with sub-queries but is there any way to do it with Criteria queries?

Thanks in advance.

Did you look at Criteria.setMaxResults(int) method? Combine that with ordering your results by some criteria (Criteria.addOrder(Order.asc/desc)), and maybe you could get what you needed.
HTH,

Bratek

org.hibernate.Query.setMaxResults(int)
and
org.hibernate.Query.setFirstResult(int)

these two will allow you to do range results (as supported by your jdbc driver) for things like pagination etc.

(gimme credits :D)