I'm building a top 10 leaderboard for contest entries and am
having some trouble with the sorting on my query. My Query is
almost working perfectly, however it doesn't seem to be ordering by
my new variable, 'entries'. Am I missing something somewhere, or is
my syntax correct? (it doesn't display at all unless I put the
single quotes on the variable entries).
<cfquery name="entry_count" datasource="clients">
select reg_id, count(reg_id) as entries
group by reg_id
order by 'entries' DESC
Thank you so much! The latter of the two worked. I'm using
[shhhhhhhhh, don't tell everyone] Access 2007, but saved as 2000 to
try and solve this issue. I'll see if it works in current format
too, some things done.