On 5/9/2007 11:12 AM, Chas Owens wrote: > my $dbh = DBI->connect($dsn, $dbun, $dbpw, {RaiseError => 1}); > > to > > my $dbh = DBI->connect( > $dsn, $dbun, $dbpw, > { > RaiseError => 1, > mysql_auto_reconnect => 1 > } > );
Yes, that works, just as a regular my $dbh = DBI->connect() inside the loop, before the SELECT. The problem is, in reality, my real code doesnt sleep in the loop, and reconnecting each time would be quite intensive. FYI, I found that when using DBD::Sybase, the problem does not exist. Should I take this over to the mysql-perl list ? Thanks! -- Jeremy Kister http://jeremy.kister.net./ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/