double oops, the nesting displayed correctly, but was not correct in
the code...the child ul's were not actually children of the li, but
rather siblings. here's correction 2 (just the corrected udf again).
<cffunction name="generate_list" output="true" >
<cfargument name="parentID" required="true"/>
<cfset var list_items = "" />
<cfquery name="list_items" dbtype="query">
SELECT sID,pID,sort,display,link
FROM joeTest
WHERE pId = #parentid#
ORDER BY sort asc
</cfquery>
<cfif list_items.recordcount gt 0>
<cfloop query="list_items">
<cfif list_items.currentrow eq 1><ul></cfif>
<cfoutput><li>#display#</cfoutput>
<cfset generate_list(sID)/></li>
<cfif list_items.currentrow eq
list_items.recordcount></ul></cfif>
</cfloop>
</cfif>
</cffunction>
On 9/27/06, Marlon Moyer <[EMAIL PROTECTED]> wrote:
oops, I forgot to var a variable and I modified the function to reduce
the number of empty ul's
<cffunction name="generate_list" output="true" >
<cfargument name="parentID" required="true"/>
<cfset var list_items = "" />
<cfquery name="list_items" dbtype="query">
SELECT sID,pID,sort,display,link
FROM joeTest
WHERE pId = #parentid#
ORDER BY sort asc
</cfquery>
<cfif list_items.recordcount gt 0>
<cfloop query="list_items">
<cfif list_items.currentrow eq 1><ul></cfif>
<cfoutput><li>#display#</li></cfoutput>
<cfset generate_list(sID)/>
<cfif list_items.currentrow eq
list_items.recordcount></ul></cfif>
</cfloop>
</cfif>
</cffunction>
On 9/27/06, Marlon Moyer <[EMAIL PROTECTED]> wrote:
> 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
>
--
Marlon
--
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/
