While this certainly works, the problem which talexb is experiencing is not related to scope of the DBI handle within the setup method of the CGI::Application class, but rather failure to explicitly disconnect the handle prior to application termination.

The incorporation of the DBI external to the CGI::Application class, while increasing the variable's scope and solving the immediate problem, to a certain extent invalidates the usefulness of the param methods and the specific scope that they offer.

Just my random thoughts on the subject.

 

perl -e 's&&rob@cowsnet.com.au&&&split/[@.]/&&s&.com.&_&&&print'