in reply to Re^3: DBD problem
in thread DBD problem

even better would be using different (so called "self documenting") names for the different statement handles, e.g. in UpdateDb
my $update = $dbh->prepare($upd_query); $update->execute ...
and in the main routine
my $select = $Dbh->prepare("SELECT " ...); $select->execute ...