Re: is there a more clever way to see if revOpenDatabases() contains a valid value?

2007-04-19 Thread Josh Mellicker
Interesting... Thanks for the info! On Apr 19, 2007, at 8:53 PM, Ken Ray wrote: On Thu, 19 Apr 2007 17:59:40 -0700, Josh Mellicker wrote: If I revCloseDatabases() or resetAll and establish a new connection before making any database command all is fine, but I am thinking this is an ineffici

Re: is there a more clever way to see if revOpenDatabases() contains a valid value?

2007-04-19 Thread Ken Ray
On Thu, 19 Apr 2007 17:59:40 -0700, Josh Mellicker wrote: > If I revCloseDatabases() or resetAll and establish a new connection > before making any database command all is fine, but I am thinking > this is an inefficient approach... or is it? > > > So I am wondering if there is any clever way,

is there a more clever way to see if revOpenDatabases() contains a valid value?

2007-04-19 Thread Josh Mellicker
I am looking for a way to check for a valid connection to a remote MySQL database (without running a test query)... Here is the problem: 1. we connect to MySQL database 2. revOpenDatabases() contains valid value, all is fine 3. every 10 minutes, our office loses internet connectivity, this