Hello Just looking for thoughts on the best way to do this..
I'm creating a site totally db-driven... And I'm looking for a way to allow a page to be in more than one section on the site... So I have 2 tables, page and section (originally enough!)... :) My thought was to make a field within page called inSection and list the sections it is in, and then to loop through and see which sections it in... However this seems awfully slow, you have to query each page and then loop through all its sections to see if its in the section you want... Is there a better way to do this? Surely there must be!! Thanks, Ryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4