Re: Closing DB handler with PerlCleanupHandler

[prev] [thread] [next] [Date index for 2004/11/10]

Batara Kesuma wrote:
> But I have a problem here, because I
> use 'our' on $dbh so other functions can use it. It looks like:
> 
> ---
> sub show_name {
>   our $dbh;
>   my $sth = $dbh->prepare("SELECT name FROM member WHERE id=?");
>   $sth->execute(1);
>   ...
> }
> 
> ## MAIN
> my $mn = MyPackage::Main::->new();
> our $dbh = $mn->load_dbh();

It looks to me like you are creating this problem by using "our".  Why 
not use "my" and pass the handle around, or put it somewhere like 
$r->pnotes() instead?

Also, why do you want to avoid persistent connections?

- Perrin

        -- 
        Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html