Dont you realize that anything after a return statement doesnt get executed? Thats not even just a "perl thing"

I guess you missed "Issue resolved by calling flush() before returning the object."

also note Auto-flushing can be unreliable for the following reasons. Explicit flushing after key session updates is recommended.If the DBI handle goes out of scope before the session variable I tend the read the documentation before i use something written by someone else!

Yes I read it. Just tried it both ways as shown in code and corrected in text.

Wit the flush before return, the fact that $session->flush() throws an error:

Software error:

Can't call method "flush" without a package or object reference at /home/jalamior/www/httpsdocs/cgi-bin/lib/perl/manageusers.pm line 198. localizes the problem to the executequery.

Ever think of looking at what is in session when you call ExecuteQuery?

see Re^8: DBI Problem, the problem is not in ExecuteQuery, the problem is where you try to do the $session->flush(); there is nothing to insure session has a valid value in ExecuteQuery.

Have you read return? Everything after a call to return is useless

Guess it does not. When I moved it ahead of return, pops up error

Can't call method "flush" without a package or object reference at /home/jalamior/www/httpsdocs/cgi-bin/lib/perl/manageusers.pm line 198.

where in ExecuteQuery is session given a value? I think this also shows you have not included use strict; use warnings; in your code either, tisk tisk !!

No tsk tsk

package manageusers;

use strict;
use diagnostics -verbose;
use warnings;
use CGI;
use CGI::Carp qw(fatalsToBrowser warningsToBrowser);
use CGI qw(:standard escapeHTML);
use CGI qw/:standard/;
use Data::Dumper;

use Digest::MD5 qw(md5_hex);
use CGI::Session;
use CGI::Cookie;
use Mail::Sendmail;
use Time::HiRes qw(usleep);
use Time::Local;
[download]

session is given a value when a user logs on. The user can do different things including changing password in the user table which is what this block of code is supposed to do..