On 25/01/07, Jared Rypka-Hauer <[EMAIL PROTECTED]> wrote:
That's not a GROUP BY, that's a COUNT()... and while you have to group to use any of the aggregate functions, it still doesn't solve the need at hand, yanno?
Aye - I was just thinking that to some extent you do get "grouped" data c/o iterators and a common group by/aggregate query is to count data subsets. The other issue is, like you say, large recordsets would require you to
retrieve the whole dataset and then get the recordCount... a lot of wasted operations.
Indeed. It was just a passing thought that might provide the means to an appropriate solution. Stephen -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
