in reply to Best way to call DBI query

As you say $dbh is set on the previous line, but what is the value of $self->param('dbh')? If you're trying to pass a reference from one CGI call to another - you can't, you'll have to use mod_perl/Apache::DBI.

rdfield