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

2007-04-20 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

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

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,