I guess you could, but wouldn't a nice sql statement, or maybe a stored procedure, be a little faster to write, maintain, and execute?
[email protected] on Friday, January 05, 2007 at 11:32 AM -0800 wrote: >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:2396 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
