btw, I would call it db design instead of db layout. >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