Jeff wrote: > 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.
How about doing a QofQ: SELECT DISTINCT PropertyID FROM single_correct_query Recordcount of that query is the number you want. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
