in reply to Method "do" error

Your code declares two lexical variables called $dbh, and each refers to a different variable. The second one masks the first - It's a brand new variable and it is undefined.

In the sub, try my $dbh = shift; in place of my $dbh;.

Replies are listed 'Best First'.
Re: Re: Method "do" error
by b310 (Scribe) on Apr 20, 2003 at 22:08 UTC
    Hi.

    I tried your suggestion with my $dbh = shift; and I'm still having no luck.
[reply]
      Where did you put the my $dbh = shift in the sub store_items or the main body of the code??

      it needs to be in the sub 

      sub store_items {
   my $dbh = shift;
   ....

      [download]

      If this is the case then follow my previous suggestion and use Data::Dumper to print out the database handle right before your error and see what you get. 

      sub store_items {
   my $dbh = shift;
   use Data::Dumper;
   print Dumper $dbh;
   ...

      [download]


      grep
      Mynd you, mønk bites Kan be pretti nasti...
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom