Return-Path: <derek.hardy@teknosys.co.uk>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 1839 invoked from network); 13 May 2003 11:39:13 -0000
Received: from mta3-svc.business.ntl.com (62.253.164.43)
  by daedalus.apache.org with SMTP; 13 May 2003 11:39:13 -0000
Received: from CIIBMLAPPY ([81.103.216.116]) by mta3-svc.business.ntl.com
          (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP
          id <20030513113911.HMKQ23713.mta3-svc.business.ntl.com@CIIBMLAPPY>
          for <torque-user@db.apache.org>; Tue, 13 May 2003 12:39:11 +0100
From: "Derek Hardy" <derek.hardy@teknosys.co.uk>
To: "Torque User Mailing List" <torque-user@db.apache.org>
Subject: Counting number of rows
Date: Tue, 13 May 2003 12:42:36 +0100
Message-ID: <IPECLJJAABLMLCLHNAFAKECBCFAA.derek.hardy@teknosys.co.uk>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0000_01C3194D.21D92140"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------=_NextPart_000_0000_01C3194D.21D92140
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi All

I'm trying to do the following, but with no luck.

select count(*)
  from property
 where store_owner = 1;

I want to be able to count the number of rows without actually retrieving
them from the database into a List.

thanks

Derek

------=_NextPart_000_0000_01C3194D.21D92140--