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
Hi!

 

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

 


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