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 24 1998 9:10PM

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.

Sorry.

It should be DBCOUNT, not DBROWS.

DBROWS is 0 if there are no rows returned by the SQL command, and 1
otherwise.

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
works.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com