Can you do a simple query that you know will return a result? Quoting Adam Gent <[EMAIL PROTECTED]>:
> Hi, > > That wont tell me an already connected, connection is still open. > > Adam > > ----- Original Message ----- > From: "John" <[EMAIL PROTECTED]> > To: "Adam Gent" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, September 19, 2003 7:28 PM > Subject: Re: mySQL, how to tell if the handle is connected > > > > $dbh->connect() or die "not connect"; > > > > ----- Original Message ----- > > From: "Adam Gent" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, September 19, 2003 9:20 PM > > Subject: mySQL, how to tell if the handle is connected > > > > > > > Hi All, > > > > > > I am using mySQL and need away to tell if a connection is open. > > > > > > I am aware that there is the Active command, within the DBI but this > does > > > not appear to be supported in DBD::mysql > > > > > > Is there any other way to tell if the connection is still open. > > > > > > Thanks. > > > > > > Adam > > > > > > > > > --- > > > Outgoing mail is certified Virus Free. > > > Checked by AVG anti-virus system (http://www.grisoft.com). > > > Version: 6.0.520 / Virus Database: 318 - Release Date: 18/09/2003 > > > > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.520 / Virus Database: 318 - Release Date: 18/09/2003 > >
