cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <>
Subject Re: Counting rows in a resultset
Date Wed, 28 Aug 2002 09:50:00 GMT
On 28.Aug.2002 -- 10:54 AM, Leszek Gawron wrote:
> try to do select count(*) as row_count from table;
> and then in <esql:row-results> do <esql:get-long column="row_count"/>
> I'm not 100% sure but this highly probable to work

Yes, if it is an option to run the query twice this should work. The
"as row_count" is not necessary if you access the count(*) by column
number i.e. <esql:get-long column="1"/>

C h r i s t i a n       H a u l
    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.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message