Re: Calling Password() via Perl Hangs

[Bobby Jones]

I just started coming on these forums and am trying to help out a bit so sorry that this post has gone unanswered for so long.

Being so long ago I hope you have already figured this problem out. If not here are some things I'd recommend. I tried all this out and couldn't reproduce your error. A few things you can try though.

#1 Don't use die statements on your web server. This can sometimes inadvertently kill the child process thus causing a hanging effect. Change them our to warns.

#2 Try putting you sql into a variable like this

my $passwd = $q->param('psword');
my $sql = qq(select password($passwd));
my $sth = $dbh->prepare($sql);
$sth->execute();

This way you can make sure it is not something odd in what you are handing back. Also double tic any incoming variables so $passwd =~ s/'/''/g;

Hope this helps you or someone in the future who reads this forum.