Owens, Howard wrote: > I have a query that returns, potentially, several hundred records. There is > a column that can contain a value between 1 and 12 (though not necessarily > 12). > > I'm trying to find a function or some method that will tell me what that MAX > value was. I know I could get the information via query, but I'd rather not > run a separate query to get this value. > > I could, I supposed, use valuelist() to make the query a list and then get > the last element of that list (which, since this is an ordered column, would > be the highest value), but that seem decidedly inefficient.
ArrayMax(queryname['column']) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
