we have a small automatied billing system, written in perl using DBI to access our MySQL database. This system utilizes various control panels for customer, webmasters,...etc... where they log in to perform various functions, submit forms,..etc.. alot of activity with our MySQL db.
what we'd like to do, is when there is any type of a database error, connection, queries,..etc,.. is then 'trapped' the error for later review, if needed, and display in the browser at the time of the error, a simple error messages to indicate there was a problem encoutered, nothing specific, then log the DBI error on the server for review.
would it be best to log in each error to a file, using something like:
if ($DBI::errstr) { $err_mesg = $DBI::errstr };
then write this to a separate error logfile ??
and is it best to set the PrintError=1 & RasieError=1 for this type of procedure ??
appreciate any suggestions or tips,
TIA -- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
