Patrick Conroy wrote:
(my $histtype, my $dsc, my $contactid, my $usrid, my $dbh) = @_;
You want
my ($histtype, $dsc, $contactid, $usrid, $dbh) = @_;
here.
my $sth = $dbh->prepare($sql_inserthistory) or die "Couldn't prepare statement: " . $dbh->errstr;
For efficiency reasons, you should prepare that statement just once, and reuse it. Possibly make it a global variable and init it in one of the OnStart event handlers.
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 don't see anywhere that you're using the $SessionID.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
