in reply to CGI::Session disconnect invalidates 1 active statement handle

Bonjour:

I think I understand your motivations, maybe it's because you have a 'lingering' session issue - you serve up a sessionid in a cookie and the user goes away forever (i.e. clears their cookies.) That session never expires because they never come back. Before you know it your session table is poopy big. :-)

Advice? Take that whole block out of 'eval {}' and watch for errors. Also, why load the session at all why not just fire off a 'DELETE FROM Session where id=$id' on te $sth?

Good Luck!
KPH

  • Comment on Re: CGI::Session disconnect invalidates 1 active statement handle