Thanks guys, I left out a lot of details- but the { } are actually a forked loop and the self that contains the mysql handle goes away for each fork. That's why I'm trying to do this- BUT I want to run sometimes forked , and sometimes not, and for the not case- I want to use the object from outside the loop.. I realize this if pretty fugly but there is a lot of motivation to do it.
But aisde from all that the real question is why does self go undef, and not use the scope outside the braces?
| [reply] |
my $main_dbh = DBI->connect(...);
while( 1 ) {
my $dbh;
if( $forked ) {
$dbh = DBI->connect(...);
} else {
$dbh = $main_dbh;
};
$dbh->selectall_arrayref($sql);
}
| [reply] [d/l] |