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: 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
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com