Thanks for applying this stuff (or alternatives) so quickly. >> EsqlQuery.java >> >> Fix paging: > >Thanks, an "else" was missing. > >> With EsqlQuery.position initialised to -1: >> I asked for 3 rows starting at 0 and got 4 rows starting at 0 >> I asked for 3 rows starting at i > 0 and got 3 rows starting at i + 1 >> with position initialised to 0 it works as expected. > >I'm not with you on this one -- according to JDBC rows are numbered >from 1.
OK so just decrease my row numbers by one then the same description applies: With EsqlQuery.position initialised to -1: I asked for 3 rows starting at 1 and got 4 rows starting at 1 I asked for 3 rows starting at i > 1 and got 3 rows starting at i + 1 with position initialised to 0 it works as expected. This was without any <esql:use-limit-clause>. The "else" that you mention - does that have something to do with this problem? Cheers, Neil. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>