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

Before select.


-----Original Message-----
From: Odelya YomTov [mailto:ode...@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-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org


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

Reply via email to