hierarchical-data

相关标签：javascript jquery android 多少钱 iPhone

Hierarchical data - Parent id or Nested set model

I\'m working on a project that required categories, I used a neste开发者_高级运维d set model and it worked out well.I have another portion of the same project, however it requires a different type of[详细]

2023-04-10 08:27 分类：问答
Working with a Model class that has a foreign/navigation key to itself

I am trying to develop a catalog project in ASP.NET MVC 3 and using EF Code first with an existing Database. There is a Categories table in m开发者_Go百科y database that points to itself. For that, I[详细]

2023-04-10 06:11 分类：问答
PHP & MySQL - get top level category with just one query

I\'m trying to get the first category (level zero, no parents) from a child category (which might be any level) with just one query with MySQL. Is that possible?[详细]

2023-04-09 05:25 分类：问答
How to visualize only the descendants, ancestors, and self of a node in a hierarchy?

In another question I asked about visualizing hierarchical data stored in a table in an SQL Server database. I found a way to visualize the whole hierarchy using GraphViz, with some plumbing in T-SQL[详细]

2023-04-05 12:07 分类：问答
basic recursive query on sqlite3?

I have a simple sqlite3 table that looks like this: Table: Part PartSuperPart wk0Zwk00 wk06wk02 wk07wk02 eZ01eZ00[详细]

2023-04-05 08:53 分类：问答
Tree traversal SQL query

Anyone, please help me with the SQL query for traversing the tree. I have a ta开发者_JAVA百科ble called users, which has the columns id, name , and parent.[详细]

2023-04-05 08:29 分类：问答
allocating content to fixed size buckets without looping in SQL Server

I am working in SQL Server 2008 R2 with a priority ordered set of content that must be assigned to a set of buckets to achieve a content specified value.Each item in the content list is related to nod[详细]

2023-04-04 18:51 分类：问答
SQL Server - Get all children of a row in many-to-many relationship?

I\'m trying to write a recursive query in SQL Server that basically lists a parent-child hierarchy from a given parent. A parent can have multiple children and a child can belong to multiple parents s[详细]

2023-04-02 15:47 分类：问答
How to get child rows in DB2 for a specific subset of parent rows?

I have a parent row and child rows on 7-10 separate tables, with a unique key tying the rows on the child tables to the parent row.For a search feature,I need to retrieve the parent and all the matchi[详细]

2023-04-01 08:59 分类：问答
how i do this in oracle pl/sql

I have the follow table: example: nodes: id_nodeid_parent -------------------- 13 32 2-1 I want to insert in other table the level of descent. For example:[详细]

2023-04-01 08:50 分类：问答