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