I'll take a closer look but it looks like a SQL solution. I'm trying to figure out the Entity Relationship Model to support a directory classification module. Nevertheless I'll take a closer and report back what I find.
---------- Original Message ---------------------------------- From: "Tangorre, Michael" <[EMAIL PROTECTED]> Reply-To: [email protected] Date: Tue, 21 Dec 2004 09:34:50 -0500 >> From: Dwayne Cole [mailto:[EMAIL PROTECTED] >> I have been trying to design relational model to manage a >> flexible directory / classification system. I want to design >> that completely seperates the directory classifaction >> relationships from the items that are being classified. That >> way I can use the same classification model to support >> classifying people, orgranizations, pictures, products and >> any other noun.... > >Read up on "nested sets". Joe Celko did a TON of work in this area and I >have implemented his strategy and techniques in a roles/permission based >security model which kind of mimics your parent/category/class idea. > >Mike > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
