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: "Ellery, Michael BGI SF" <Michael dot Ellery at barclaysglobal dot com>
Subject: RE: ct_sql
Date: Apr 9 1999 6:06PM

er, how about 

  $num  = scalar(@ows);

or just,

  $num = @rows; # being implicit

but that only works for this case (i.e. a select...)

I guess you want something more like:

  $num = $dbh->{ROW_COUNT};

...it's something like that, anyhow.

Michael Ellery
Barclays Global Investors
45 Fremont St., 6th Floor #102
San Francisco, CA  94105
(415) 908-7234 [PH],  (415) 597-2352 [FAX]
Email:  michael.ellery@barclaysglobal.com

> -----Original Message-----
> From:	Andrew J Davies [SMTP:Andrew.J.Davies@aib.ie]
> Sent:	Friday, April 09, 1999 8:43 AM
> To:	SybPerl Discussion List
> Subject:	ct_sql
> 
> Hi all
> is there a way of identifying the number of rows affected by a sql
> statement using ct_sql.
> 
> @rows =  $dbh->ct_sql( select * from table1);
> 
> thx
> Andy
> 
> 
> 
>