I usually do a recursive custom tag to make my trees. I haven't tried using UDFs for it because of database calls, but with CFMX, I'm sure it would be nice. I haven't used the nested sets model before, but I have briefly looked at it. My problem with it seems that it's not normalized at all. In that Intelligent Enterprise article, the lft and rgt columns seem like they could easily go out of wack if you're not careful. A single table with a recursive parent ID seems much logical.
Sure, there are some more database calls, but it all depends on what you're trying to do. For example, we have an application with an advanced permissions system that involves cascading permissions and some other tidbits. When the user logs in, their permissions are pulled through recursive custom tags and set to the session scope. It's a one time thing for each login so any extra load is really not noticeable. Ben Johnson Hostworks, Inc. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
