db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joacim Turesson" <joacim.tures...@profuture.se>
Subject [Newbie] Getting limited number of rows
Date Tue, 09 Mar 2004 09:35:11 GMT


I'm using Torque and it works fine:-)


I'm working with a webbapplication and I want to display a limited
amount of a data in a list.


How do I get a limited number of rows, and still knows how many total
number of rows there exist?


As I understand:

*	setOffset indicates from where I start (zero based)
*	setLimit indicates how many rows from the offset I get


Do I have to do a select count statement with the criteria above without
offset and limit to get the total number of rows?

Or is it a better way?


Best Regards


Joacim Turesson


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message