I have come to the conclusion that passing perl parameters from one perl
subroutine to another just doesn't work in CGI. It looks like everything
is passed by value, and the language is not set up to take refs. This
being the case, how best to handle the following piece of DBI code:
my $dbh = DBI:connect($connectionString); # connect to the database
my $sth = $dbh->prepare($cmd); # prepare a command
What I think that I have found is that
my $dbh = DBI:connect($connectionString) # dbh is a global variable set
in a global context
..
sub fubar{
my $sth = $dbh->prepare($cmd);
}
seems to work, but it does not work to have the global variable set inside
a subroutine and accessed from another. If it were a character string, I
would use hidden() to pass the values from one subroutine to another, but
the cgi macros are not set up to handle ref variables!
If I am right, that I can set $dbh globally and access it from some
subroutine, can I do this
if (something is true) {
my $dbh = DBI:connect($connectionString);
}
sub fubar{
my $sth = $dbh->prepare($cmd)
I've been wrestling with this problem for several hours, now, and would
appreciate hearing from someone who knows more about this!
Thanks.
Mary Anderson
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
