cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: Counting rows in a resultset
Date Wed, 28 Aug 2002 08:59:45 GMT
On 28.Aug.2002 -- 10:48 AM, Tuomo Lesonen wrote:
> 
> 
> 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, there is nothing in the JDBC API that provides this data that
I'm aware of. There are certainly vendor specific procedures to get
this information.

However, most of the time the output needs to be limited, in order to
page through the data. This is supported by esql.

	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>


Mime
View raw message