Since a query will not be producing any output, I would suggest to put it inside a <cfsilent> block so eliminate all white space.
Thanks On 3/1/07, Mark A Kruger <[EMAIL PROTECTED]> wrote: > > Ah... Well I don't use the GUI ... Just query analyzer.. The script > generator code is actually quite good.. > > -----Original Message----- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 01, 2007 3:32 PM > To: CF-Talk > Subject: RE: Formatting your SQL Statements > > When people do that build-query thing they select tables and drag-drop to > hook up foreign keys. The SQL code that that generates is almost > offensive. > It seems to randomly break lines and indent. > > Not sure where it is as I never use it. > > > ....................... > Ben Nadel > Certified Advanced ColdFusion MX7 Developer www.bennadel.com > > Need ColdFusion Help? > www.bennadel.com/ask-ben/ > > > -----Original Message----- > From: Mark A Kruger [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 01, 2007 4:04 PM > To: CF-Talk > Subject: RE: Formatting your SQL Statements > > What do you mean? Out of like ... Firehose mode? I use query analyzer to > write and it formats splendidly - as does the script generator... > What part of SQL server are you rioting against :) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271225 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
