Alternatively, you could probably get the group count into the query
result set itself by using
SELECT name, subname, count(subname) as subnameCount, cola, colb, colc
from tableName
order by name, subname
group by name, subname, cola, colb, colc
Rick
j s wrote:
> Is it possible to get the Recor
Baz wrote:
> You could create a counter:
That's how I generally do it but if you need the count at the beginning
of the group, or during the output of the group, then your alternative
would be to pass the query to a UDF that you write whose sole purpose is
to determine the count of the current
You could create a counter:
#Name#, #RecordCount#
#SubName#, #RecordCount#
Baz
-Original Message-
From: j s [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 28, 2006 11:11 AM
To: CF-Talk
Subject: RecordCount of query group
Is it possible to get the RecordCount of cf qu
Is it possible to get the RecordCount of cf query group?
#Name#, #RecordCount#
#SubName#, #RecordCount#
Not automatically the way you are doing it. You can either do something in the
query with group functions, or you can count them in your output.
#Name#
#SubName#
4 matches
Mail list logo