Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » When I set FirstResult and MaxResult how I can get the total ( count() )(regardless of the first and maxResults values?)
When I set FirstResult and MaxResult how I can get the total ( count() ) [message #533957] Mon, 17 May 2010 14:51 Go to next message
No real name is currently offline No real name
Messages: 7
Registered: April 2010
Junior Member
Hi!

I have a query that I set firstResult and maxResult because I use the result in a dataTable with paginator. But I also need to know how many results, the total I have without the firstResult and maxResult params. Exist a way to get this value or I will always need to do a second query with count() ?
Re: When I set FirstResult and MaxResult how I can get the total ( count() ) [message #533980 is a reply to message #533957] Mon, 17 May 2010 15:24 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

You need to do a second query with count.


James : Wiki : Book : Blog : Twitter
Previous Topic:Prevent errors in log when using drop-and-create-tables for eclipselink.ddl-generation
Next Topic:Implementing aggregate boolean functions in JPQL?
Goto Forum:
  


Current Time: Mon Sep 22 10:27:10 GMT 2014

Powered by FUDForum. Page generated in 0.09015 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software