Category Archives: Nested Set Trees

Nested Set Trees in ColdFusion (v1.0)

A common technique to manage hierarchical data in a relational database is to use an "Adjacency List" model, where you have both an ID column and a Parent ID column in a table. This is easy to understand and maintain but can be difficult or inefficient when you want to retrieve hierarchies of records. The [...]
Posted in Nested Set Trees | Tagged | Comments closed

Nested Set Trees in ColdFusion (v0.8)

A common technique to manage hierarchical data in a relational database is to use an "Adjacency List" model, where you have both an ID column and a Parent ID column in a table. This is easy to understand and maintain but can be difficult or inefficient when you want to retrieve hierarchies of records. The [...]
Posted in Nested Set Trees | Tagged | Comments closed

Nested Set Trees in ColdFusion (v0.2)

A new version of this project is available. A common technique to manage hierarchical data in a relational database is to use an "Adjacency List" model, where you have both an ID column and a Parent ID column in a table. This is easy to understand and maintain but can be difficult or inefficient when [...]
Posted in Nested Set Trees | Tagged | Comments closed

Nested Set Trees in ColdFusion

A new version of this project is available. A common technique to manage hierarchical data in a relational database is to use an "Adjacency List" model, where you have both an ID column and a Parent ID column in a table. This is easy to understand and maintain but can be difficult or inefficient when [...]
Posted in Nested Set Trees | Tagged | Comments closed