RE: DBD ODBC question - $dbh->{odbc_exec_direct}

[louis gonzales]

Hey Ryan,
Actually, I noticed the stale handle error you were getting and with a 
little intuition, without digging in too deep, figured it had to do with 
the method being called and not closing "finishing" before the next 
iteration of the same method call.

Glad it solved the issue!

       Regards,

On Thu, 15 Dec 2005, Ryan Stille wrote:

louis gonzales wrote:
Try
sth->finish()
after the
sth->execute()

I tried this and it did indeed stop the errors, even without the
"$dbh->{odbc_exec_direct} = 1" line.  Actually I added it after the
fetch, I wasn't sure if I should clean up $sth before I fetch() from it.

What was happening by not calling finish()?  My recollection was that
this is not usually necessary.

Thanks,
-Ryan


--
LLL         OOOO          UUU     UUU    IIII     SSSSS
LLL       OOO  OOO        UUU     UUU    IIII   SSSS
LLL      OOO    OOO       UUU     UUU    IIII  SSS
LLL     OOO      OOO      UUU     UUU    IIII SSS
LLL    OOOO      OOOO     UUU     UUU    IIII SSSSS
LLL    OOOO      OOOO     UUU     UUU    IIII   SSSSS
LLL     OOOO    OOOO      UUUUUUUUUUU    IIII     SSSSS
LLL      OOOO  OOOO        UUUUUUUUU     IIII     SSSS
LLLL      OOOOOOOO           UUUUU       IIII  SSSSSS
LLLLLLLL   OOOOOO             UUU        IIII SSSSS
LLLLLLLL