Database error messages

As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.  However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.  The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.  All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.  In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line, with wrapping. Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.  Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it.  If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.  ;) Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral bboisvert@audiencecentral.com voice : 360.756.8080 x32 fax   : 360.647.5351 cell  : 360.319.6145 www.audiencecentral.com

Whoops, no attachements on cf-talk.  That must be cfczone that lets them through.  I can't post it online right now, but if anyone's interested, email me off list, and I'll shoot you the archive. Cheers, barneyb ----- Excess quoted text cut - see Original Post for more -----

Pls send me a copy thx Dick On May 4, 2004, at 3:47 PM, Barney Boisvert wrote: ----- Excess quoted text cut - see Original Post for more -----

Hey Barney can you put them on a web server and give us the URL? This will save you on all the sending stuff. TK   Whoops, no attachements on cf-talk.  That must be cfczone that lets them   through.  I can't post it online right now, but if anyone's interested,   email me off list, and I'll shoot you the archive.   Cheers,   barneyb   > As you know, the CF error message for database errors displays the SQL   > statement that caused the error, the datasource, and error   > cods.  However,   > it DOESN'T display the values of stuff passed through   > CFQUERYPARAM.  The   > information is there (as is evidenced by the debugging   > output), but it's   > just not used.   >   > I rectified that problem with the modified error templates   > included in the   > attached archive.  All values passed through CFQUERYPARAM are   > now listed   > after the SQL statement itself, in the same format as on the debugging   > output.  In addition, the SQL statement is PRE formatted so   > it appears as in   > the code, rather than all on one line, with wrapping.   >   > Installation is simple, just extract the archive into your   > /WEB-INF/exception directory, and overwrite the two files it   > prompts.  Four   > additional UDFs are installed as well.   >   > The code is public domain, so do whatever you want with it.   > If any of the   > MM guys are listening, I'd love to see this or something equivalent in   > Blackstone.  ;)   >   > Cheers,   > barneyb   >   > ---   > Barney Boisvert, Senior Development Engineer   > AudienceCentral   > bboisvert@audiencecentral.com   > voice : 360.756.8080 x32   > fax   : 360.647.5351   > cell  : 360.319.6145   >   > www.audiencecentral.com   >   >   >

That's the plan, but I can't do it right now for various reasons.  Hopefully I can post it tonight sometime.  When I do, I'll send the URL to the list. Cheers, barneyb ----- Excess quoted text cut - see Original Post for more -----

[repost from yesterday, with download link] As you know, the CF error message for database errors displays the SQL statement that caused the error, the datasource, and error cods.  However, it DOESN'T display the values of stuff passed through CFQUERYPARAM.  The information is there (as is evidenced by the debugging output), but it's just not used. I rectified that problem with the modified error templates included in the attached archive.  All values passed through CFQUERYPARAM are now listed after the SQL statement itself, in the same format as on the debugging output.  In addition, the SQL statement is PRE formatted so it appears as in the code, rather than all on one line with wrapping. http://www.barneyb.com/go/cf_exception Installation is simple, just extract the archive into your /WEB-INF/exception directory, and overwrite the two files it prompts.  Four additional UDFs are installed as well. The code is public domain, so do whatever you want with it.  If any of the MM guys are listening, I'd love to see this or something equivalent in Blackstone.  ;) Cheers, barneyb > Hey Barney can you put them on a web server and give us the > URL? This will > save you on all the sending stuff. > > TK

Barney, I'd love that error handling code.  I'll give you a plug on my blog. -mark   Whoops, no attachements on cf-talk.  That must be cfczone that lets them   through.  I can't post it online right now, but if anyone's interested,   email me off list, and I'll shoot you the archive.   Cheers,   barneyb   > As you know, the CF error message for database errors displays the SQL   > statement that caused the error, the datasource, and error   > cods.  However,   > it DOESN'T display the values of stuff passed through   > CFQUERYPARAM.  The   > information is there (as is evidenced by the debugging   > output), but it's   > just not used.   >   > I rectified that problem with the modified error templates   > included in the   > attached archive.  All values passed through CFQUERYPARAM are   > now listed   > after the SQL statement itself, in the same format as on the debugging   > output.  In addition, the SQL statement is PRE formatted so   > it appears as in   > the code, rather than all on one line, with wrapping.   >   > Installation is simple, just extract the archive into your   > /WEB-INF/exception directory, and overwrite the two files it   > prompts.  Four   > additional UDFs are installed as well.   >   > The code is public domain, so do whatever you want with it.     > If any of the   > MM guys are listening, I'd love to see this or something equivalent in   > Blackstone.  ;)   >   > Cheers,   > barneyb   >   > ---   > Barney Boisvert, Senior Development Engineer   > AudienceCentral   > bboisvert@audiencecentral.com   > voice : 360.756.8080 x32   > fax   : 360.647.5351   > cell  : 360.319.6145   >   > www.audiencecentral.com   >   >   >