Time to take out some heavier arms. Since I only need to get "id" and "name" from my table, I'm placing these pairs in a hashtable inside <esql:row-results/>. Then I have a nice hashtable, which I iterate through later on. hashtables "size()" method gives the rowCount.
BUT: How to implement "Enumeration" interface in XSP in order to use the "keys()" method of the Hashtable object? (I'm pretty new to Java, so there's probably a convinient way of doing this..) -Tuomo On Wed, 28 Aug 2002, Christian Haul wrote: > 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"/> > > 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]>
