It is a SQL Editor. You can write _anything_. On Thu, Mar 25, 2010 at 10:11 AM, <> wrote: > > >>Inside a cfquery, right click and do SQL Editor. > > Thanks for the tip. > The video show how to build a select with an ORDER BY clause. > Is there any provision for more complex clauses and queries like WHERE, > GROUP BY, UNION, > or JOINs ? > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
