Getting info on SQL errors

[JerrySeattle]

I am using Flash Remoting to ColdFusion to Microsoft Access. When I make a
mistake in formulating my SQL statement I get the standard "Error Executing
Database Query" message via NetDebug, but that is all of the information I get.
When I program in VisualBasic against Microsoft Access via OLEDB I get very
robust error messages from Access. Is there any way I can get such robust
error messages in the ColdFusion environment, or do I just have to live with
the "Error Executing Database Query" message. Thanks

[paross1]

I'm not familiar at all with Flash Remoting, but you might check your Debugging
& Logging > Debugging Settings in ColdFusion Administrator. The default for
Enable Robust Exception Information is normally disabled, and the description
for this option is as follows:

Lets visitors view detailed information in the exceptions page, including the
template?s physical path and URI, the line number and snippet, the SQL
statement used (if any), the data source name (if any), and the Java stack
trace.

Phil

[JerrySeattle]

Thanks Phil. I tried what you suggested but it does not seem to make any difference.

[LL@Work]

See Dorange's comments here:
[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p24.htm[/url]