On 8 Sep 2003 at 14:15, Jack Coxen wrote: > sub run_query { > # print "Query: ", $statement, "\n"; > my $sth = $dbh->do($statement) > or die "Can't prepare $statement: $dbh->errstr\n"; > $numrows = ($sth->rows); # This is where the problem is > print $numrows; > }
This is a DBI question, not a MySQL question. Have a look at the documentation for the do() method in DBI. It returns the number of rows, not a statement handle. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]