mnlight has asked for the wisdom of the Perl Monks concerning the following question:
my($dbh) = @_; my @datamodels; my %filenames; my %dbids; my $sql = "select DATAMODEL_CD, DB_ID, FILENAME from PRDRELEASE wh +ere RELEASE_FG = 1"; my $sth = $$dbh->prepare($sql) or $app->error($FATAL, "Can't do SQL statement [ $sql ] :: +$DBI::errstr"); $sth->execute(); while (my @values = $sth->fetchrow_array()){ push (@datamodels, $values[0]); $dbids{$values[0]} = $values[1]; $filenames{$values[0]} = $values[2]; }#end while loop printf("@datamodels\n"); my $numelements = @datamodels; return (\@datamodels, $numelements, \%dbids, \%filenames);
my ($datamodels, $numelements, $dbids, $filenames) = get_data(\$dbh);
my ($dbh, $datamodel, $date, $numelements, $filenames) = @_; my $file = "$filenames{$datamodel->[$count]}" print "$file\n";
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Returning and passing references to hashes
by ikegami (Patriarch) on Jan 04, 2006 at 18:48 UTC | |
by mnlight (Scribe) on Jan 04, 2006 at 19:59 UTC | |
|
Re: Returning and passing references to hashes
by Roy Johnson (Monsignor) on Jan 04, 2006 at 18:37 UTC |