Like the topic suggests, I am looking for an efficient way for implementing the
depth first traversal of the records in the table in a MSSQL database.
The table structure contains the following information for maintaining the
hierarchy of the records.
Cat_id
Parent_id
Now what I am trying to do is to display the records in the table using the
hierarchical structure.
So, for a given parent_id, I would first traverse all the child records in the
table for that particular parent_id before I can move to the next parent_id.
What is the best way for me to traverse the records and display the information?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:1924
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
