Thanks, Perrin. Exactly what I was looking for but couldn't find. And Rob Landrum, thanks as well. I'm actually planning to store the database connections persistently as a (global)module hash--after I finish the conversion to mod_perl.
Walt > -----Original Message----- > From: Perrin Harkins [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 17, 2001 3:23 PM > To: Walt Knowles; [EMAIL PROTECTED] > Subject: Re: Help with converting from plain CGI to mod_perl > > > > Converting all the globals to Module variables has been a > piece of cake, > but > > I've run into one big issue. Depending on how you log into the > system, the > > user will connect to different databases. When they do this, I > store the > > Database Handle from DBI/DBD as $main::dbh. This variable has > the scope of > > "the length of processing the request" and then should become undef. > > The best way to do this under mod_perl is to store it in > $r->pnotes(). It's > documented in perldoc Apache, as well as the guide and the eagle book. > - Perrin
