Rick, Try this site http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl. You put in the SQL and how you want it formatted and it comes right back formatted.
Steve -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 9:18 PM To: CF-Talk Subject: Re: code formatters I'd like to see a code formatter for SQL. I don't know how many times I copy and paste the a coldfusion query provided to me by cfcatch or cferror, and have to go through and format it so I can figure out what it does and why it didn't work :) Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

