you could try using a structuary ----- Original Message ----- From: "Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 8:27 AM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
