Hi S. Isaac, this worked fine after some tweeking. Currently my first query returns 24 rows of records (because there are currently for constituencies returning results and each has 6 parties participating), but the logic beats me, how is it that your
>> <cfquery name="PartyConstituencyResults" datasource="#request.datasource#"> > >After this query, add a query of query that gets the top 1 record sorted >by totalVotes desc: > ><cfquery name="WinningConstituency" dbtype="query" maxrows="1"> > select * from PartyConstituencyResults > order by TotalVotes desc ></cfquery> > >That oughta do it. :) > >hth > >-- >s. isaac dealey ^ new epoch > isn't it time for a change? > ph: 781.769.0723 > >http://onTap.riaforge.org/blog ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:313030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4