modifiy $sth->execute();
with $num_rows = $sth->execute() or die "Unable to call execute $!\n\n"; Regards, Amit Saxena On Mon, Jul 14, 2008 at 6:30 PM, luke devon <[EMAIL PROTECTED]> wrote: > could you please direct me how could I implement those steps in to the code > ? > > > > ----- Original Message ---- > From: Thomas Bätzler <[EMAIL PROTECTED]> > To: Perl <beginners@perl.org> > Cc: luke devon <[EMAIL PROTECTED]> > Sent: Monday, July 14, 2008 16:05:21 > Subject: RE: Perl script doesnt behave well > > luke devon <[EMAIL PROTECTED]> asked: > > I am using perl script to handle some function of squid > > redirector program . Actually its working fine. But after > > some time , that functions goes off. That's meant VALUE-A > > doesnt comes in to the request. > > Is it possible that your script has lost the connection > to the database? From what I see of your code you don't > check the return value from $sth->execute. > > You really should do that, and possibly use $dbh->ping() > at the head of the while loop to determine wether you > need to reconnect to your database. > > HTH, > Thomas > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > http://learn.perl.org/ > > Send instant messages to your online friends http://uk.messenger.yahoo.com >
