Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Database error messages
Author: Barney Boisvert
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162317
[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
Author: Mark A. Kruger - CFG
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162274
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
>
>
>
Author: Barney Boisvert
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162252
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 -----
Author: Tom Kitta
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162251
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
>
>
>
Author: Dick Applebaum
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162250
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 -----
Author: Barney Boisvert
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162248
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 -----
Author: Barney Boisvert
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32328#162247
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
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
