Sushil, You use SQL syntax to limit your result set. Like this:
SELECT * FROM MYTABLE LIMIT 1,10 will give you the results starting from the first one, all the way until the next 10 (1-10). SELECT * FROM MYTABLE LIMIT 50,10 Will give you the results starting from the 50th, all the way until the next 10 (50-60). HTH. -Zack Nostromo Corporation -----Original Message----- From: sushil Bhattarai [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 12:28 PM To: [EMAIL PROTECTED] Subject: esql question Hi all, My esql query is returning huge amount of data (many rows). I know there's a way to limit the number of rows but I do need all rows. But I want to display only 10 rows at a time. And then next 10 rows and so on. Is there a way to do that? Sushil _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
