Cross-over between sessions

[Patrick Conroy]

Hello all,

I am trying to see if I can make use of subs in global.asa to
consolidate redundant code across Apache::ASP pages, but I seem to be
getting cross-over between sessions.  My subs are of all set up like
this example:

sub history
{
        (my $histtype, my $dsc, my $contactid, my $usrid, my $dbh) = @_;

        my $sql_inserthistory = "insert into history (histtype, dsc,
contactid, crusr) values (?, ?, ?, ?)";

        my $sth = $dbh->prepare($sql_inserthistory) or die "Couldn't
prepare statement: " . $dbh->errstr;
        $sth->execute($histtype, $dsc, $contactid, $usrid) or die
"Couldn't execute statement: " . $sth->errstr;
}


But, I wind up getting a lot of history records from one user written
with the usrid of another user in a different session.  I assume that
whatever I am doing wrong is basic Perl or mod_perl stuff, rather than
specific to Apache::ASP, but I am hoping someone here can help me, or
at least point me in the right direction.  Any help would be greatly
appreciated.

Thanks,
Patrick

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]