Say I have a table with the following records:
rec id description parent id
1 Test Record 1 0
2 Test Record 2 1
3 Test Record 3 1
4 Test Record 4 3
5 Test Record 5 3
6 Test Record 6 4
7 Test Record 7 4
8 Test Record 8 3
The parent id field relates a record to its parent. I want to display the
records in a list so that children records are listed indented under their
parent. There can be an infinite number of nested parents and children, so there
could be many indents in the list. The output in this example should look like
this:
Test Record 1
Test Record 2
Test Record 3
Test Record 4
Test Record 6
Test Record 7
Test Record 5
Test Record 8
Could somebody give me direction on how to program this? Sample code?
Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
