Here is an overview of what I'm trying to solve. Records are selected based on meeting two criteria. Within each selected record there is a region field. This region field is not unique in the table. Region is used to join another table with an associated field called siteid which is unique to the second table. Also in the second table is a field called service area. There are 3 service areas (West, Central, East). Each service area has several hundered unique siteid. I need to count how many records are associated with both the service area and site id. Since there are several hundered siteid. I figured using a multidimensional array to load the siteid, search though it and add a 1 for every instance it occurs. Is this the best way to go about tackling this? Any suggestions, comments, examples, etc would be stellar. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2394 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
