Ah... Although this may work as a starting point .... I would recommend that you learn to write queries by hand. For the most part advanced techniques will not ba accessible to you by way of a wizard. The access query builder, Query Analyzer, Auqua... All of them are capable of giving boiler plate select, update and insert code... But a join or union or aggregate functions with "group by" or "having"... You pretty much have to learn how to actually write that sort of code.
For example, if you use Access to create JOIN query you will not get JOIN syntax. Instead you will get what I usually refer to as the "Access" join syntax. Instead of Select a.col1, b.col2 >From tableA a JOIN tableB b ON a.col3 = b.col3 You will get something like... SELECT tableA.col1, tableB.col2 FROM tableA, tableB WHERE tableA.col3 = tableB.col3 This will work.. And there's not technically wrong with it - but it is not using JOIN.... So it is not symantic ... Add 4 or 5 more tables in there and some aggregate views and the query builder will no longer even be able to give you that much. Having said all that - you can use query analzer to drop specific object names into the query window.. This might cut down on typos. Also practicing your typing would cut down on typos and probably help in other areas as well :) -Mark -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Friday, November 30, 2007 7:35 AM To: CF-Talk Subject: RE: sql editor 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
