jb.
On Tue, 24 Aug 2004 09:53:04 -0400, Anne Girardeau <[EMAIL PROTECTED]> wrote:
> 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]
