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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209170 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
