Creating a List from a Recursion

[Anne Girardeau]

I've created a custom tag that recurses over a database to create a breadcrumb trail.  The problem I'm encountering is I would really like to be able to pull a list from that tag that it can then be easily manipulated.  Below is the custom tag code:

<cfquery name="checkParent" datasource="#request.siteDSN#">
SELECT Keywords.KeyID, Keywords.Keyword, Keywords.Title, Keywords.ViewID, Keywords.AppID, Navigation.ParentID, ParentName.Keyword AS ParentName, ParentName.Title AS ParentTitle
FROM (Navigation AS Parent RIGHT JOIN (Keywords RIGHT JOIN Navigation ON Keywords.KeyID = Navigation.KeyID) ON Parent.NavID = Navigation.ParentID) LEFT JOIN Keywords AS ParentName ON Parent.KeyID = ParentName.KeyID
WHERE keywords.keyword = '#attributes.child#'
</cfquery>

<cfloop query="checkParent">

<cfquery name="checkNextParent" datasource="#request.siteDSN#">
SELECT Keywords.KeyID, Keywords.Keyword, Keywords.Title, Keywords.ViewID, Keywords.AppID, Navigation.ParentID, ParentName.Keyword AS ParentName, ParentName.Title AS ParentTitle
FROM (Navigation AS Parent RIGHT JOIN (Keywords RIGHT JOIN Navigation ON Keywords.KeyID = Navigation.KeyID) ON Parent.NavID = Navigation.ParentID) LEFT JOIN Keywords AS ParentName ON Parent.KeyID = ParentName.KeyID
WHERE keywords.keyword = '#checkParent.parentName#'
</cfquery>

<cfoutput>

<cfif checkNextParent.recordcount NEQ 0>
<cf_breadcrumbs child="#checkParent.parentName#" breadcrumbs=" > <a href=''>#checkParent.ParentTitle#</a>"  siteDomain="#attributes.siteDomain#">
</cfif>

</cfoutput>

</cfloop>

<cfoutput>
#attributes.breadcrumbs#
</cfoutput>

Currently the breadcrumbs display directly from the custom tag which works relatively well.  Except there are instances when I would really like to have the data placed into a list.  Any ideas how I could accomplish this?  Any help would be greatly appreciated.

--Anne

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---