Rabish Kumar wrote:
When i do select quiery and then try to get count of rows like this in perl
script from Oracle database and Informix:
$rowCnt = $sth->rows;
above line is being executed after the $sth->execute;
But before you've fetched the rows, presumably. Have you read the DBI documentation on ->rows()?
http://search.cpan.org/~timb/DBI-1.48/DBI.pm#rows
-- Keith Ivey <[EMAIL PROTECTED]> Smokefree DC http://www.smokefreedc.org Washington, DC
