sushil Bhattarai wrote:
> 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?
esql let's you limit the number of rows to display at a time e.g. start
at x and display y rows. Consecutive calls could start at another x.
Your DBMS might have a SQL extension that allows the same (see e.g.
Zack's post).
You could use the FilterTransformer together with the SQLTransformer and
store the result in the session. See docs for both plus samples for how
to use that.
In addition, there's a PaginatingTransformer in scratchpad that might be
useful, too.
HTH
Chris.
---------------------------------------------------------------------
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]>
