Forgive me in advance for the heresy, but try MS Access's query builder. It is pretty easy to use and gives you three choices for viewing the results...one of them is sql. That view gives you the sql you can cut and paste anywhere.
Mark -----Original Message----- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Friday, November 30, 2007 7:29 AM To: CF-Talk Subject: sql editor Hi everybody: I need to make some complex cfqueries and I wonder if there any easy to use software is out there I can use to make the sql statements easier than writing down all of them. I don't mind if it is a 3rdparty program or a cfeclipse addon or a dw extension, I just need something to help me drag and drop my Database tables into that and make the relationships and the program gives me the sql script without bugs cause when I write them they have some typo and non-typo bugs and it makes my life really hard. Thanks benign ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
