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?
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.
J
------------------------------------------------
Jared C. Rypka-Hauer
Continuum Media Group LLC
http://www.web-relevant.com
Member, Team Macromedia - ColdFusion
"That which does not kill me makes me stranger." - Yonah Schmeidler
On Jan 25, 2007, at 10:20 AM, Stephen Moretti wrote:
It occurs to me that there kind of is grouping in Reactor via
iterators.
If you're group by is to get a count of invoices for a client for
instance, you would get your client record and then get the
recordcount for the invoice iterator. eg.
rsClient = reactor.createRecord('client').load(ID=form.clientid);
invoicecount = rsClient.getInvoiceIterator().getRecordCount();
It'll probably not be very efficient for large record sets.
Hope that helps
Regards
Stephen
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
