Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 50206 invoked by uid 500); 28 Aug 2002 09:50:15 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 50187 invoked from network); 28 Aug 2002 09:50:15 -0000 Date: Wed, 28 Aug 2002 11:50:00 +0200 From: Christian Haul To: cocoon-users@xml.apache.org Subject: Re: Counting rows in a resultset Message-ID: <20020828115000.Z23145@bremen.dvs1.informatik.tu-darmstadt.de> Reply-To: haul@dvs1.informatik.tu-darmstadt.de References: <20020828090040.81F7D4223@gondolin.kompuart.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20020828090040.81F7D4223@gondolin.kompuart.pl> User-Agent: Mutt/1.3.22.1i Organization: Databases and Distributed Systems Group, Darmstadt University of Technology X-MailScanner: Found to be clean X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N On 28.Aug.2002 -- 10:54 AM, Leszek Gawron wrote: > try to do select count(*) as row_count from table; > > and then in do > > 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. 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. To unsubscribe, e-mail: For additional commands, e-mail: