SELECT [n] nested sets

2008-08-12 Thread John Smith
Hi, there is a table with several trees in nested set form in it. CREATE TABLE IF NOT EXISTS `posts` ( `id` int(11) unsigned NOT NULL auto_increment, `root_id` int(11) unsigned NOT NULL, `lft` int(11) unsigned NOT NULL, `rgt` int(11) unsigned NOT NULL, `date` datetime NOT NULL, PRIMAR

Re: Re[2]: nested sets - Perhaps a solution!

2004-07-26 Thread Alexander Newald
[how to store userpermissions in a tree in mysql] Hi, after a long time of try and error I have this as a result: mysql> select * from node; +-+-+-+-+-+--+--+--+ | node_id | root_id | payload | lft | rgt | a| c| d| +-+-+

Re: Re[2]: nested sets

2004-07-26 Thread Alexander Newald
[Aman's view of my problem] Hi, I think you know what my problem is. My "solution" so far is (from another mail): -- snip -- The main problem I have to do the "rollback". A 2nd table is no option because it might be possible that another users rights get be change before the rights of the firs

Re: Re[2]: nested sets

2004-07-26 Thread Aman Raheja
On Mon, 2004-07-26 at 10:24, DebugasRu wrote: > Hello Aman, > > Monday, July 26, 2004, 6:03:07 PM, you wrote: > > >> Hello, > >> > >> I have a question related to nested sets: > >> > >> On my website a user should be able to create su

Re[2]: nested sets

2004-07-26 Thread DebugasRu
Hello Aman, Monday, July 26, 2004, 6:03:07 PM, you wrote: >> Hello, >> >> I have a question related to nested sets: >> >> On my website a user should be able to create subusers and give them the >> rights to add/change/delete subsites of the users website.

Re: Re[2]: nested sets

2004-07-26 Thread Alexander Newald
> Hello Aman, > [..] > > I think he was talking about user roles. > one creates a role and then assigns that role to the users. > When one changes the role rights then automatically users' rights > change according to the roles they have. > The main problem I have to do the "rollback". A 2nd tab

Re: nested sets

2004-07-26 Thread Aman Raheja
it. HTH a bit! On Mon, 2004-07-26 at 09:46, Alexander Newald wrote: > Hello, > > I have a question related to nested sets: > > On my website a user should be able to create subusers and give them the > rights to add/change/delete subsites of the users website. If I remove on

nested sets

2004-07-26 Thread Alexander Newald
Hello, I have a question related to nested sets: On my website a user should be able to create subusers and give them the rights to add/change/delete subsites of the users website. If I remove one or more rights to a user all of its subusers should have the same restrictions as the user. If I

RE: nested sets vs. key path method

2001-02-13 Thread Jon Haworth
ll [mailto:[EMAIL PROTECTED]] Sent: 13 February 2001 11:13 To: [EMAIL PROTECTED] Subject: Re: nested sets vs. key path method >Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is

Re: nested sets vs. key path method

2001-02-13 Thread Bob Hall
>Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is situated on really fast SELECT statements. > >Actually I'm using nested sets like: > >CREATE TABLE

nested sets vs. key path method

2001-02-12 Thread Christian Fellner
Hello, at the time I try to figure out what's the best way to get a kind of parent/child - hierarchy with unlimited subchild. My special attention is situated on really fast SELECT statements. Actually I'm using nested sets like: CREATE TABLE Personnel (emp CHAR(10) P