What version of SQL Server are you using?
On 12/16/2010 5:24 PM, Adam Cameron wrote:
On Dec 17, 12:27 am, Carl Von Stetten<[email protected]> wrote:
I misspoke. I meant that you cannot use an alias that refers to an
aggregate function value (like count, max, min, etc.) in the order by
clause. If you merely provide an alias on a database field (i.e.:
myfield AS mynewfield), you can use that in the order by clause.
But hang on. In the example the alias IS on an aggregate function:
<cfquery name="allUsersLogins" dbtype="query">
select loggins, count(*) as total from allUsers where account_active
= 1
Group By loggins
Order By total Desc
</cfquery>
I've just fixed my SQL Server install and verified this runs fine.
--
Adam
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
