Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 6903 invoked by uid 500); 28 Aug 2002 09:00:52 -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 6892 invoked from network); 28 Aug 2002 09:00:51 -0000 Date: Wed, 28 Aug 2002 10:59:45 +0200 From: Christian Haul To: cocoon-users@xml.apache.org Subject: Re: Counting rows in a resultset Message-ID: <20020828105945.Y23145@bremen.dvs1.informatik.tu-darmstadt.de> Reply-To: haul@dvs1.informatik.tu-darmstadt.de References: <20020828093543.X23145@bremen.dvs1.informatik.tu-darmstadt.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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: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 > > > 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 , 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. To unsubscribe, e-mail: For additional commands, e-mail: