Requirements: I am building a task list application and wanted tasks to be able to have sub-tasks. I also wanted tasks to be able to exist in multiple places in the tree at once, for example, if I ha
I have a table in my database which conains a nested set of items, with significant columns being id and parent. parent always points to the row id it is nested within.
I\'m trying to populate a table set with more root Locations nested three levels: Region, Province and City.
What issues are associated with maintaining multiple tress within a single table? The motivation for having multiple trees is to avoid excessive updates to all nodes when inserting a node at the star
I\'ve got a nested model called categories and I have created a nested form to allow creation of a category and sub categories in one form.
I\'m really struggling with a nested set query in our PHP/MySQL driven shop, I\'ll use electronics parts as an example.
I\'m using Rails 3.0.7 with awesome_nested_set and I\'m trying to create a nested form which will allow me to enter a category and sub categories all in one create form.
I am currently developing a comment system for a website that I am working on.I did a lot of research and decided to use the nested set model to store my comments.I have created procedures to add and
I have a database table called users This table has two columns (that are important) uuid, and parentUuid
Example: SELECT `cat`.`id_catalog`, COUNT(parent.id_catalog) - 1) AS `level` FROM `tbl_catalog` AS `cat`, `tbl_catalog` AS `parent` WHERE (cat.`left` BETWEEN parent.`left` AND parent.`right`) GROUP B