ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Odelya YomTov" <ode...@jpost.com>
Subject RE: size of paginated list
Date Wed, 22 Jul 2009 19:56:12 GMT
Right
But I prefer not to call 2 different queries.. can I do it in one query?



-----Original Message-----
From: Andrey Rogov [mailto:konusdb@gmail.com] 
Sent: Wednesday, July 22, 2009 9:44 PM
To: user-java@ibatis.apache.org
Subject: RE: size of paginated list

select count(*) 
  From your_table
<dynamic>
     Your expression
</dynamic>

Before select.


-----Original Message-----
From: Odelya YomTov [mailto:odelya@jpost.com] 
Sent: Wednesday, July 22, 2009 11:17 PM
To: user-java@ibatis.apache.org
Subject: size of paginated list

Hi!
I need to know the size of the paginated list (not per page).
Because if I do:
orderList.getPageSize - I get the amount of records per page, and I need to
know in general how many records are there in the database.

For example:
If my page size is 10, and the query should return 15, it should tell me 15
and not 10.
How can I do it?


Thanks|!


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org

 
 
****************************************************************************
********
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer
viruses.
****************************************************************************
********



---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message