cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tuomo Lesonen <tleso...@cc.hut.fi>
Subject Re: Counting rows in a resultset
Date Wed, 28 Aug 2002 07:48:56 GMT


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
> haul@informatik.tu-darmstadt.de
>     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:     <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