following table structure
ID NAME PARENT_ID
1 category1 0
2 category1_1 1
3 category1_2 1
4 category1_1_1 2
5 category1_1_2 2
6 category2 0
7 category3 0
I would like to be able to do some sort of recursive process and put
this information into a structure to output to a page.
i.e.
category1
category1.category1_1
category1.category1_2
category1.category1_1.category1_1_1
category1.category1_1.category1_1_2
category2
category3
I've got the following code but I'm getting stuck on the recursive
bit.....
<cfset startpoint = 0>
<cfset tree = StructNew()>
<cfset getlevel=getchildren(startpoint)>
<cffunction name="getchildren">
<cfargument name="parentID">
<cfset var qry_tree="">
<cfquery datasource="#application.dsn#" name="qry_tree">
SELECT * FROM test
WHERE Parent_ID = #arguments.parentid#
</cfquery>
<cfoutput>
<cfloop query="qry_tree">
<cfset name2="category" & currentrow>
<cfset tree["category#currentrow#"] =
qry_tree.name>
</cfloop>
</cfoutput>
</cffunction>
<cfdump var="#tree#">
Any advice on how to build the hierarchical structure? Would a CFC be
better?
Thanks in advance.....
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
