All, I have been working to create an application to display data via a infinite series of categories and sub-categories. The look I am going for is similar to the home page of Yahoo.com:
Category1 Category2 - Sub1 -Sub1 -Sub1 - Sub2 -Sub2 -Sub2 Category3 Category4 - Sub3 -Sub3 -Sub3 - Sub4 -Sub4 -Sub4 Category5 Category6 - Sub5 -Sub5 -Sub5 - Sub6 -Sub6 -Sub6 (There is no actual content displayed on this page, just categories) When you click any of the items above, you are taken to another page that actually has the content. It would look like this: Sub1 Sub2 - SubSub1 SubSub1 - SubSub2 SubSub2 data data data data And so on... until there was only data on the page because no more sub categories exist. I have my database Category table set up to include: CatID (Primary Key) CatName ParentID (Refers to CatID that is the "owner" of this particular CatID) CategoryLevel (specifics which level of the hierarchy this Cat is) I have tried several different approaches to writing the code, but none of them output the stuff. Again, I am trying to set this up to be infinitely deep so no matter how many categories/sub-categories are created, this single piece of code will continue to work. Has anyone else solved this problem and mind sharing the code, or pointing me in the right direction? Thanks in advance! Jake FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
