Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Obtaining rowcount when updating
Date: Sep 25 1998 2:47PM
Simon Yaminian writes:
> In my scripts, I do $dbh->dbnextrow between the $dbh->dbresults and the
> $dbh->DBCOUNT calls and this apparently throws DBCOUNT off. So when I obtain
> the DBCOUNT right after the $dbh->dbresults call, it generates the right
> rowcount. However, I noticed that DBCOUNT is -1 when the sql call is a 'select'.
> In this case doing a $dbh->DBCOUNT after all $dbh->dbnextrow calls are
> exhausted, produces the right row count. Is this normal?
Yes, I guess it is.
I haven't used DBCOUNT much, though.
Michael Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com