Skip to main content
S
SpiderFromMars
Inspiring
December 4, 2009
Question

CFQUERY Debug

  • December 4, 2009
  • 1 reply
  • 966 views

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

I can't seem to get it to output anything

    This topic has been closed for replies.

    1 reply

    D
    Daverms
    Inspiring
    December 5, 2009

    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

    S
    SpiderFromMarsAuthor
    Inspiring
    December 7, 2009

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices