Barney,

I'd love that error handling code.  I'll give you a plug on my blog.

-mark

  -----Original Message-----
  From: Barney Boisvert [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, May 04, 2004 5:48 PM
  To: CF-Talk
  Subject: RE: Database error messages

  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

  > -----Original Message-----
  > From: Barney Boisvert [mailto:[EMAIL PROTECTED]
  > Sent: Tuesday, May 04, 2004 3:39 PM
  > To: CF-Talk
  > Subject: 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
  > [EMAIL PROTECTED]
  > voice : 360.756.8080 x32
  > fax   : 360.647.5351
  > cell  : 360.319.6145
  >
  > www.audiencecentral.com
  >
  >
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to