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 :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4