If you're using CF7, have a look at CFQUERY.sql. I doubt it'll be formatted great but it should have the white space removed.
Take a screen grab and put it somewhere for us to see what you mean. Adrian -----Original Message----- From: marc -- Sent: 11 July 2007 20:41 To: CF-Newbie Subject: Remove whitespace from query in debug window 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2898 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
