PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Lee Falkenhagen" <falkenl at hotmail dot com>
Subject: Re: number of rows?
Date: May 21 1998 3:53PM

I usually just have an incrementor in my dbnextrow loop that keeps count 
of the number of rows selected.  Since you have to loop through all the 
rows, it is not much overhead.

Lee


>From owner-sybperl-l@listproc.net Thu May 21 07:35:15 1998
>Received: from IDENT-NOT-QUERIED@list.cren.net (port 60740 
[204.153.50.13]) by outbound.Princeton.EDU with SMTP id <541487-2603>; 
Thu, 21 May 1998 10:27:18 -0400
>Received: from otter.mbay.net (root@otter.mbay.net [206.40.79.2])
>	by list.cren.net (8.8.7/8.8.7) with ESMTP id KAA21249
>	for ; Thu, 21 May 1998 10:26:56 -0400 (EDT)
>Received: from kiruna.peppler.org (mty1-64.dip.mbay.net 
[206.55.224.64])
>	by otter.mbay.net (8.8.8/8.8.8) with SMTP id HAA18305
>	for ; Thu, 21 May 1998 07:26:58 -0700
>Received: by kiruna.peppler.org (SMI-8.6/SMI-SVR4)
>	id HAA10571; Thu, 21 May 1998 07:26:42 -0700
>From:	Michael Peppler 
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Date:	Thu, 21 May 1998 07:26:41 -0700 (PDT)
>To:	SybPerl Discussion List 
>Subject: number of rows?
>In-Reply-To: 
>References: 
>X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs  Lucid
>Message-ID: <13668.14643.419980.244450@kiruna>
>Reply-To: SYBPERL-L@listproc.net
>Sender: owner-SYBPERL-L@listproc.net
>X-Listprocessor-Version: 8.2.06 -- ListProc(tm) by CREN
>
>H. Siegling writes:
> > Hi !
> > 
> > I'm working with Sybperl 2.09 on NT.
> > Is it possible to get the number of rows that '$dbh->dbresult' 
generated ?
> > '$rows=$dbh->DBCOUNT' doesn't work.
>
>It does work if you ran an update/delete/insert operation. It does NOT 
>work if you did a select. That is the way it's supposed to work. See
>the documentation on DBCOUNT() in Sybase's DBlibrary manual
>(http://sybooks.sybase.com if you don't have sybooks installed
>locally).
>
>Michael
>-- 
>Michael Peppler         -||-  Data Migrations Inc.
>mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
>Int. Sybase User Group  -||-  http://www.isug.com
>
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com