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: Karsten Spakowski <spacki at pol dot de>
Subject: NUMBER of affected rows
Date: May 10 2001 11:26AM

Hi folks,

I work with the DBI and DBD Module on a Sybase Server 11.9.

After the execution of an select statement,  I will check the number of
affected row,
but I get always the -1.

my $sth = $dbh->prepare("Select name from patient
                                            where name = \"Anybody\"");
my $rc = $sth->execute();
print "$rc affected rows \n";

while (my @row = $sth->fetchrow_array()) {
    print "Row: @row \n";
}

Even if I have some affected data,
the variable $rc told me always the number of affected rows are unknown.

Does anybody  know what could be causing this problem?

Thanks in advance.
Karsten Spakowski