Methinks Joe is getting awfully cheap consultant work here :)
Sorry, I tried to put it all on one line, but gmail kept on inserting breaks. :(
This was tested against bluedragon, but I don't think it will have a
problem with 6.1 or above
<cfquery datasource="whatever" name="joeTest">
SELECT sID,pID,sort,display,link
FROM yourtablehere
</cfquery>
<cfset parentid = 0/>
<cffunction name="generate_list" >
<cfargument name="parentID" required="true"/>
<cfquery name="list_items" dbtype="query">
SELECT sID,pID,sort,display,link
FROM joeTest
WHERE pId = #parentid#
ORDER BY sort asc
</cfquery>
<cfloop query="list_items">
<ul>
<cfoutput><li>#display#</li></cfoutput>
<cfset generate_list(sID)/>
</ul>
</cfloop>
</cffunction>
<cfset generate_list(0)>
On 9/27/06, Joe Kelly <[EMAIL PROTECTED]> wrote:
Got another one for you....
Given: attached parent/child table (txt or mdb)
Wanted: a cf generated heirarchal nested list with list items under
their respective parents
Requirements: none, if you use components, keep them all in one cfc
for ease of reading. The nesting could be unlimited.
Results should look something like the following:
Home
[EMAIL PROTECTED]
Project Manager Development
Open Projects
Close Projects
Applications
Workgroups
Current Workgroups
Historical Workgroups
General Information
Social Side of Work
Resources
etc.....
Good luck!
Thanks,
Joe Kelly
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Marlon
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
