laziness, impatience, and hubris | |
PerlMonks |
Re^8: DBI Problemby huck (Prior) |
on Sep 30, 2017 at 03:11 UTC ( [id://1200416]=note: print w/replies, xml ) | Need Help?? |
Session is given a value here $session = OpenSession($dbh,$tsid); Your use of globally scoped lexical variables has gotten you in trouble before too, when you dont know what you are doing it is a bad practice. i suspect the flush belongs in OpenSession Again i ask where in ExecuteQuery is session given a value?, Pay attention now, HOW DO YOU INSURE SESSION HAS A VALUE WHEN ExecuteQuery IS CALLED so you can use it to call the flush method? It should be my $session = OpenSession($dbh,$tsid); and my $session = new CGI::Session("driver:MySQL", $sid, {Handle=>$dbh, LockHandle=>$dbh}); to insure session has a value when you use it rather than being possibly unitialized like it is at times now!
In Section
Seekers of Perl Wisdom
|
|