I wasn't saying that you wouldn't have to look up the permissions if you used nested sets. Rather, that you can look up the permissions in a single (quite simple) query, no matter how your tree is, or how deep you have to go to get to the ancestor node with the actual permissions.
cheers, barneyb On Mon, 21 Mar 2005 09:01:52 +0100, Micha Schopman <[EMAIL PROTECTED]> wrote: <snip /> We might have used the Joe Celko model > but it wouldn't mattered in the end result, the permissions still need to be > looked up. <snip /> -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
