Right But I prefer not to call 2 different queries.. can I do it in one query?
-----Original Message----- From: Andrey Rogov [mailto:konu...@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: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 **************************************************************************** ******** 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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
