Just a general note that any time you run a query and then loop over it and run more queries, there's almost always a way to accomplish the same task using a single query (which will be far more efficient).
On Fri, Mar 6, 2009 at 4:17 PM, Sin Tec <[email protected]> wrote: > > Im doing a loop within a loop to get the distinct Category in the records > for a business directory. It works great if there is just one column of > categories but I have it set up where you can add the record in three > different categories. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
