in reply to Re: Re: Re: accessing Apache::DBI 'cached connections'
in thread accessing Apache::DBI 'cached connections'

i had the connect string completely wrong.

it's fixed now, and reads: 

$DBH = DBI->connect( "dbi:mysql:rentsavers", "root", "", ) ;

[download]
i can't believe i blew the $dsn ....

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: accessing Apache::DBI 'cached connections'
by perrin (Chancellor) on Jul 21, 2003 at 21:49 UTC
    This is why you have to check return values or turn on RaiseError.
[reply]

      Agreed. Unless you're really diligent, turning on RaiseError is better. You can always wrap in an eval when you rally want somthing other than death.

      I turn on RaiseError. ;-/

      --Bob Niederman, http://bob-n.com
[reply]
      yes, agreed. i thought i was getting info from the startup.pl .. but that doesn't seem to be the case. maybe subject for different node ... but i've preloaded CGI::Carp ... 
      # Tell me more about warnings
use CGI::Carp qw( fatalsToBrowser warningsToBrowser );
$SIG{__WARN__} = \&Carp::cluck;

      [download]
      but i'm not getting the fatalsToBrowser behaviour i'm supposed to ... normal 500 error messages, not Carp output
[reply]
[d/l]
        If you mean that you aren't getting the same connection that you tried to set up in startup.pl, that's because you aren't sending in the same connection parameters. They have to be identical.

        CGI::Carp is kind of a hack and people often have trouble with it.

[reply]

In Section Seekers of Perl Wisdom