See $sth->{ParamValues} (and $h->{ShowErrorStatement} and $h->{HandleEvent})Tim. On Thu, Apr 01, 2004 at 11:33:55AM -0500, [EMAIL PROTECTED] wrote: > Hi all, in my application errors are trapped in a sub that prints: > > 1) a notice to the user indicating an exception has occurred; > 2) the name of the script (w/ absolute path), user and $DBI::errstr > 3) the failed query itself wrapped in pre tags for readability > (this is a web app) > > One thing needs improvement: the failed query prints the question mark > placeholders for my bound params/variables. Is there a quick and > dirty way to have at the values the placeholders represent (i.e., > values passed in the $sth->execute($i, $love, $dbi); statement? > > The ability to print these params along with the failed query (or in > place of it as the question marks render it less than useful) is what > I'm after...without having to rewrite my many scripts. > > Any tips greatly appreciated! > > Cheers > ----------------------------------------------------------------------- > Thomas Good e-mail: [EMAIL PROTECTED] > Programmer/Analyst phone: (+1) 718.818.5528 > Residential Services fax: (+1) 718.818.5056 > Behavioral Health Services, SVCMC-NY mobile: (+1) 347.524.5631 > > // It is better to vote for what you want and not get it, than to > // vote for what you don't want and get it. -- Eugene V. Debs >
