Up Prev Next
From: sy50027 at milton dot sbi dot com (Simon Yaminian)
Subject: Re: Obtaining rowcount when updating
Date: Sep 24 1998 10:02PM
> From owner-SYBPERL-L@listproc.net Thu Sep 24 17:49:15 1998
> From: Michael Peppler
> Mime-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Date: Thu, 24 Sep 1998 14:10:08 -0700 (PDT)
> To: SybPerl Discussion List
> Subject: Re: Obtaining rowcount when updating
> X-Listprocessor-Version: 8.2.07 -- ListProc(tm) by CREN
> Simon Yaminian writes:
> > I tried getting the number of rows using $dbh->DBCOUNT after an update
> > and it returned 0. Even with the insert, it returned 0.
> It should be DBCOUNT, not DBROWS.
> DBROWS is 0 if there are no rows returned by the SQL command, and 1
> BTW this is documented in the Sybase manuals that are available on
> line at http://sybooks.sybase.com. Please make an effort to look
> things up - it will give you a better understanding of how DBlibrary
> Michael Peppler -||- Data Migrations Inc.
> firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
Thanks for the reply,
If you notice in my message, I did use DBCOUNT (and not DBROWS - I looked
up both before trying them) and it still produced 0 as the rowcount.