Tony Esposito wrote:
> This question has never been answered. To out it another way, given the code ...
>
> foreach my $mytable (@mytables) {
> my $sth = $dbh->prepare("SELECT COUNT(*) FROM mytable");
> # report error but move on to next table
> }
>
> how do I ignore the situation/error that DBI throws when $mytable does not exist and just move on to the next table?
Why would you want to?
Why not just ask the database which tables are there?
If you really want to do it in an ugly way, then
first read "perldoc DBI" about "err" and "errstr"
and "RaiseError", etc.
--
Ruud
|