> He added the order by desc, so that it sorted the highest to lowest..
> Had it been asc, you would have gotten the four smallest returns.
Parkhill makes the layup! :)
He's right the "order by TotalVotes desc" in the query sorted the
results highest to lowest and then maxrows="1" just cut it down to the
records you want off the top.
--
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:313033
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
