Eddie,
Thanks for the tip. It suddenly occurred to me what I was doing
wrong. I do use an error trap but I was telling my script to stop
running after the error. So, now I ignore it and continue through the
loop you suggested. I guess it was working exactly the way I had
written it!
Thanks!
Floyd
On Jul 10, 2009, at 11:23 AM, Eddie Drapkin wrote:
On Fri, Jul 10, 2009 at 10:56 AM, Floyd Resler<fresler@adex-
intl.com> wrote:
I'm having a hard time getting my head around this problem. I have
to
connect to a FoxPro database using an ODBC driver. Sometimes when
I connect
I get an error. The error doesn't occur all the time and usually
another
connect attempt works. I can trap the error through an error
handler.
However, I use a class to connect to the database. What I want to
do is to
check for that error and, if it occurs, try to connect again.
Since the
error handler is outside the class, how can I create the object
again and
make sure it gets passed back to my script that called it? I hope
that made
sense!
Thanks!
Floyd
Why is the error outside the class? If you connect with a class,
something like:
public function __construct() {
$this->handle = false;
while($this->handle === false) {
$this->handle == odbc_connect();
}
}
ought to work fine. Alternatively, you could check out PDO, which is
supposed to be the next generation of database connections in PHP, and
won't create an object without a connection.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
