I'm not a DBI guru but I guess if you "try and catch" your DBI exception handling
with eval, you can exit properly at all.
I mean:
eval{
$dbh=DBI->connect($connect_string);
$sth=$dbh->prepare($sql);
$sth->execute();
#some fetch here
$sth->finish();
$dbh->disconnect();
}
if($@)
{
print "program failed because : $@\n";
exit;
}
Jos�.
rory oconnor <[EMAIL PROTECTED]> a �crit :
Regarding perl DBI - I know it's proper to use $sth->finish and
$dbh->disconnect and I am doing that at the end of my script...
however, i am also doing alot of error checking at the beginning of the
script (to make sure data has been entered, and formatted properly). If
there's an error I would usually just send back an error message and
exit the script to prevent it from having to run through the rest of it
needlessly. do I need to explicitly disconnect before exiting in those
instances or it it OK to just exit?
thanks,
rory
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Yahoo! Mail -- Une adresse @yahoo.fr gratuite et en fran�ais !
