hierchical data

[fu-meng]

hi.

i'm building a dynamic tree in coldfusion and i've been reading how to format
hierarchical data in my database. it certainly seems like a tough task ( as i
am a novice CF'er ), but i've read good articles on the nested set model, the
adjacency list, and the modified preorder tree traversal algorithm.

now the project i'm building won't have more than a few hundred records but
i'm still weary of using a recursive method ( like the nested model, which is
what i am leaning towards ) to retrieve tree data. i'm just worried about
excess overhead issues. i was just hoping someone real ( apart from an article
) might be able to chime in with their two cents.

any advice, personal experience, and tips are very much appreciated.

fumeng.

[PaulH]

see if [url]http://www.barneyb.com/blog/archives/000532.jsp[/url] is of any use.

[fu-meng]

hi paul.

thank you for your response to my post. yes, that is exactly what i was
looking for. the only drawback is that his implementation only supports 1 root
node instead of multiple root nodes. i may just contact him and ask if i can
extend it to handle that functionality.

thanks again for your post.

fumeng.