CFQUERY Debug

[SpiderFromMars]

Has Anyone ever used the 'debug' flag in the CFQUERY tag?

I can't seem to get it to output anything

[Daverms]

Hi,

Well, it doesn't really show you any output.

Rather It just controls the display of  "SQL Queries" section in your debugging information. It will be very useful in situations like, where you want to hide the SQL Queries / stored procedures in the debugging information

And this is what the documentation has to say about this "debug" attribute,

• Yes, or if omitted: if debugging is enabled, but the Administrator Database Activity option is not enabled, displays SQL submitted to datasource and number of records returned by query.

• No: if the Administrator Database Activity option is enabled, suppresses display.

HTH

[SpiderFromMars]

Thanks for your response on this.

Here's another case where I found it useful:

When there is a template that runs which has lots of queries on it and you want to concentrate on one particular query, you can turn 'Database Activity' off in the CF administrator and turn debug="yes" in the CFQUERY tag you wish to study. Very useful to cut down on the size of page your debugging generates.

Something else I notice, this does not work if debugging is not turned on in the CF Admin.