Re: [OpenBD] Re: Query of Queries

[Alan Holden]

How about this? One less pass:

<cfquery name="allUsers" datasource="#APPLICATION.dbSource#">
select loggins, count(*) as total, column3, column4, column5, column6
from users
where account_active = 1
Group By loggins
</cfquery>

<cfquery name="allUsersLogins" dbtype="query">
select * From allUsers
Order By total Desc
</cfquery>

Al

--
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