Error Executing Database

Question

I am familiar with the 400 and 500 custom error page setup
option in the control panels of many shared server hosts, but I
have other error pages that come up infrequently that I'd like to
mask.

Every now and again, I'll get a situation where one of my
pages comes up "Error Executing Database Query" and my code,
Datasource, etc. are all listed right there.

How can I prevent this (besides fixing the coding problem)?
Is there a structural method I'm not using, or a custom error page
I don't know of? I'm a low level CFmx coder, so education in
security would be beneficial

Thanks,
Stephen
Tallahassee, FL

JMGibson3 · Answer

You can create your own custom error handlers displaying onlydesired content and doing other things like e-mailing or logginginto a error log database (where you can record the stuff that YOUwant to see). They can be enabled via the CFERROR tag, presumablyin each application.cfm, or an easier approach is the Site WideError Handler setting in the Administrator\Settings if you can usethe same logic for all. Be aware that debugging a new one can bevery tedious, strange happenings when the handler itself has anerror. You may have to resort to displays and cfaborts. You canalso find limited info in the application.log. As I recall (and itis probably version dependent) an error in the error handlerreverts to displaying the original error in the old format. Justfor jolly's to get you started,I've attached mine, for MX 7.01only, with a database and conditional e-mail.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded