The pseudocode below is a little off. The loop condition should be while counterA is LTE queryA's recordcount *or* counterB is LTE queyrB's recordcount.
>Initialize two counters - counterA and counterB - to 1 -- you begin by >looking at the first record from each query > >loop while both counters are LTE their respective recordcount >--compare queryA.score[counterA] and queryB.score[counterB] >--if the score from B is GT the score from A >----output info for B, iterate counterB >--else >----output info for A, iterate counterA >end loop > >One thing to remember - you can go through all the records of one >query before the other query is finished so you need to test for that. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
