On Wed, 28 Aug 2002, Christian Haul wrote:

> On 28.Aug.2002 -- 10:07 AM, Tuomo Lesonen wrote:
> > Hi,
> >
> > How can I count the rows in my resultset? I'm using esql, but
> > <esql:row-count/> doesn't seem to be implemented yet. SQL COUNT(*) doesn't
> > work in this case either. Can I do this with XSP?
>
> Yes, have a new var declared before the execute-query and ++ it in
> your row-results
>

Thank you Chris, but in this case I need to know the number of rows
_before_ I do <esql:row-results>, in order to produce the right data.

-Tuomo

> ...
> <xsp:logic>
>               int rowCount = 0;
> ...
>               <esql:execute-query>
> ...
>                               <esql:row-results>
> ...
>                                   <xsp:logic>
>                                           rowCount++;
>
>
>       Chris.
> --
> C h r i s t i a n       H a u l
> [EMAIL PROTECTED]
>     fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
>
> ---------------------------------------------------------------------
> 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]>
>


---------------------------------------------------------------------
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]>

Reply via email to