I believe MX 7 still supports aggregrates in query of queries. Check out http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001266.htm for the QoQ guide and http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001272.htm for using aggregate functions in QoQs.
Is there a particular piece of code that the analyzer flagged as a problem? Regards, Phillip On 6/9/05, dan martin <[EMAIL PROTECTED]> wrote: > I am upgrading from 5.0 to mx7 and just ran the analyzer. One of the > informational flags it raised was on query of queries no longer supporting > key words like COUNT() in the query of queries. > > Does this mean you can no longer use any group by or any aggregate functions > on the query of queries? > > The work around suggested by the analyzer is to remove the keywords. Not very > helpful. > > Anyone know how to do group by aggregates in MX7? It works fine in cf5.0 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
