Hi, I have a page with some cfqueries that are build with lots of conditional cfml. When I request the page and click the "debug this window" link at the bottom I go to the "debugging details" part and click "SQL queries". I see the queries as they are received by the database - sql with lots of whitespace. All cfml is removed by whitespace, and when an sql clause is not applied it is not shown here - biuut instead I see white lines. For debugging purposes I often run this generated SQL copy in phpMyAdmin so I copy and paste it. Lots of whitespace is an annoyance. Can't you remove this to get a nicely formatted sql query?
I tried: Manage white space in the admin: won't do it; Setting <cfsetting cfoutputonly="yes"> at the top of the page: won't do it; Enclosing the query in <cfsilent> tags: won't do it. Looks like all these directives are ignored because this is the *debug* window I'm looking at - not the *source of the cf page I am requesting*. Is that true? Is there a way to remove ws in that debug window too? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2894 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
