cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Gallardo" <agalla...@agsoftware.dnsalias.com>
Subject Re: Help with <esql:more-results>
Date Thu, 26 Dec 2002 08:04:15 GMT
Hi:

I was checking the code behind esql. I think the problem is related to the
new LIMT OFFSET in the Query:

If we set the limit of returned rows the database will return in the
recordset only the numbers of rows that we requested with the LIMIT
keyword. That means that we cannot know if there are more rows. XSP does
not know it too and then the <esql:more-results> do nothing.

I thinked that we can change this because one of the use of the
<esql:more-results> tag is pagination. If we cannot know if there are more
rows then we cannot make use of the "previous page" and "next page"
approach.

I hope you will resolve this issue or please tell us how to resolve this.

Thanks in advance,

Antonio Gallardo



Antonio Gallardo dijo:
> Hi!
>
> I am trying to make use of <esql:more-results> in a simple PostgreSQL
> database page using XSP. I am using Cocoon 2.1 CVS (today - 25-Dic-02 at
> night CST). My problem is that the <esql:more-results> is not working. I
> know already there are more than 50 registers of the database that can
> be retrieved.
>
> <snip>
> <esql:execute-query>
>   <esql:query>
>     <esql:use-limit-clause/>
>     <esql:skip-rows>1</esql:skip-rows>
>     <esql:max-rows>10</esql:max-rows>
>     <esql:results>
>       <table><header-stuff/>
>         <esql:row-results>
>           <esql:previous-results>previous rows</esql:previous-results>
> <esql:more-results>more rows</esql:more-results>
>           <td><esql:get-string column="name"/></td>
>         </esql:row-results>
>       </table>
>     </esql:results>
>   </esql:query>
> </snip>
>
> The point is: everything works well but the more-results is not working
> no matter if you put it as descendant of <esql:results> or
> <esql:row-results>
>
> My database is PostgreSQL 7.2 on Red Hat Linux 7.2
>
> Please help me.
>
> Regards,
>
> Antonio Gallardo
>
>
>
> ---------------------------------------------------------------------
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>




---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message