Cool, I had done something similar while wiating for a reply... So its good to hear someone else backing up that idea!
Thanks, Ryan Date: 08/07/2003 02:38 PM Author: Paul Giesenhagen Short Link: http://www.houseoffusion.com/lists.cfm?link=m:4:26195:131908 Create PageTable ---------------------- pageID, content Fuse Table (this table brings the pages and sections together) ---------------------- fuseID, sectionID, pageID Section Table ---------------------- sectionID, sectionName Then, you can call ALL pages that have sectionID = XX Thus, a pageID can be in multiple rose in the Fuse table. Make sense? Hope this helps! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Ryan Mitchell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 07, 2003 9:59 AM Subject: Database layout question... > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
