You could use the calculated data set, create a new query using QueryNew and then do a Query of Queries (QoQ) and re-sort it that way, then display.
A drawn out process but works. Les Mizzell wrote: >Page in Question: http://www.cyndustries.com/bugmusic_vote_completed.cfm > >(Unless you're into very experimental electronic music I wouldn't advise >listening to any of the pieces!! Otherwise, hide your cat!!!) > >There's a table holding the info for each piece >There's a table where all the scores are stored > >So, the page is set up like this: > ><Cfoutput query="MUSICSELECTION"> > > <cfloop query="getscores"> > <!--- Code to count the number of votes in > each catagory for each piece and total here ---> > </cfloop> > > ><!--- Code to average scores for each catagory > (total score / number of votes ---> > ><!---DISPLAY SECTION SHOWING SCORES AND TOTALS ---! > ></cfoutput> > >Here's the question - How could I get the DISPLAY SECTION to list in >decending order of TOTAL SCORE? > >Hindsight: I could have calculated all these values each time somebody >voted and added a field to the database and sorted on that. I wasn't >thinking about that when I rushed to get the voting up for the client. I >*could* just add a field and update the database when voting is finished >and sort - but I'm curious if there's anyway to do it without touching >the database again. Ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:195318 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
