I am creating a breadcrumb navigation for our new site but the output is not
what I want - it is backwards and I am not sure what to do.
First, the queries:
This one is in my header. Needs to be called each time. Although these are
actually CFC's and Stored Procs, I am showing just the query for simplicity
sake:
SELECT *
FROM tblPages
WHERE ID = 12 AND Status = 'A'
Here is the result of the query:
ID parentID
Title
Status Hierarchy
12 3 Current Board Members
A 12~3
Now the bredcrumb code:
<cfset CrumbList = "">
<cfloop list="#getPagesRet.hierarchy#" delimiters="~" index="i">
<cfinvoke
component="CFC.Admin"
method="getPages"
returnvariable="getPagesRet2">
<cfinvokeargument name="ID" value="#i#"/>
</cfinvoke>
<cfset CrumbList = #CrumbList# & ' > <a
href="Default.cfm?ID=#getPagesRet2.ID#"
target="_self"> #getPagesRet2.Title#</a>'>
</cfloop>
<cfoutput>
#Variables.CrumbList#
</cfoutput>
So if I am looking at Board - Current members, the breadcrumb should be
Board > Current Members. What I am getting is Current Members > Board.
I am thinking that since the Hierarchy is 12~3 and not 3~12, this is the
issue. So in the database, I changed it to 3~12 and I get an error Element
HIEARCHY is undefined in GETPAGESRET2 when I click on Current Members.
So is there something else I can look at?
Thanks,
--
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285479
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
