Okay, how about this... Is there a function or a combination of functions that I can use on the query results to find the distinct PropertyIDs from a join query?
Say my query returns 10 rows. 2 distinct properties, with 6 rates for one, and 4 rates for another...so grouped output looks like this: My Property One 112 Address Drive [photo 1] Rate Schedule 1 Rate Schedule 2 Rate Schedule 3 Rate Schedule 4 Rate Schedule 5 Rate Schedule 6 My Property Two 234 Address Drive [photo 2] Rate Schedule 1 Rate Schedule 2 Rate Schedule 3 Rate Schedule 4 Your search returned [#DistinctPropertyCount#] Is there some way to calculate #DistinctPropertyCount# some way from the results of the query? In this case, the RecordCount is correct (10 rows returned) but what I *really* need is the number of *properties* that are returned... Make sense? on 6/12/03 3:07 PM, Jeff at [EMAIL PROTECTED] wrote: > on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote: > >> I've run into this one before and it sucks. Your best bet, if you want the >> number of unique property ids is to run another query that does a >> SELECT COUNT DISTINCT propertyID AS pCount... >> >> But whether or not it will work to use this number as the recordcount is >> anyone's guess. You may have to keep track manually. >> > > You're kidding me... > > I had thought about "jury-rigging" it by doing exactly that. But thought I'd > be ashamed of doing something like that... > > Am I correct in assuming that the recordcount of the join is actually > correct? It's a fact that I can verify whenever I group them properly (by > grouping them on propertyID) and it always comes out correct. This leads me > to believe that the query is actually *THE* correct way to retrieve this > information in this particular manner...it's just going to be a pain to do a > "next n records" browse type of function? > > Is this correct? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
