By grouped do you mean in the query or in the cfoutputs? If it's the outputs, why not try incrementing a counter inside the inner most output? But this assumes you don't want the count before the output!
Ade -----Original Message----- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 13:27 To: CF-Talk Subject: Array or Struct...which would be more 'do-able' for something like this... I'm doing a fairly complex join, and the recordcount of that join is a different number than I actually need because I group the output. For instance, I might have a recordcount of 13, but since the output is grouped around, say, PropertyID, what you really see, are 2 properties. One with 7 rates, and one with 8 rates, from the join. This means that my query returns 8 PropertyIDs from one property, and 7 PropertyIDs from another property. What I'd like to do, is somehow come up with the count of unique propertyIDs from the query results. I thought, rather than run another query to get count and have two queries, I'd rather try to use the existing query and determine the count of unique PropertyIDs from the single, correct query. I had an idea to loop over that query, populating some sort of data structure but possibly checking for the existence of that PropertyID before inserting it, ending up with a list or a struct with only unique propertyIDs in them. Then, simply get the length or number of items in the array or struct. Am I approaching it the right way? Would it be easier (and by easier, I mean, least amount of code overhead as possible) to use a struct, or an array to do this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
