Well, this is what I have.
It is spitting out the breadcrumbs options perfectly...however, they are
in reverse order of what I need them in.
=============
<CFIF isDefined('URL.Cat') and URL.cat NEQ 0>
BreadCrumbs: <A href="tryagain.cfm?Cat=0">Main</A>
<CFQUERY name="findBread" datasource="Categories">
SELECT *
FROM Categories
WHERE ItemID= #URL.Cat#
</CFQUERY>
<CFSET countVar=1>
<CFSET next=#findBread.ParentItemID#>
<CFIF #findBread.ParentItemID# GT 0>
<CFLOOP From="#findBread.CategoryLevel#" TO="1" step="-1" INDEX="i">
<CFSET countVar=countVar + 1>
<CFQUERY name="findBread2" datasource="Categories"
maxrows="1">
SELECT *
FROM Categories
WHERE ItemID= #next#
</CFQUERY>
<CFOUTPUT> > #findBread2.Item# (#next#)</CFOUTPUT>
<CFSET next=#findBread2.ParentItemID#>
</CFLOOP>
</CFIF>
</CFIF>
Any and all help is appreciated
-----Original Message-----
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 9:16 PM
To: CF-Talk
Subject: RE: CFLOOP sort order
What sort of a loop is it?
<cfloop index="counter" from="999" to="1" step="-1">
-----Original Message-----
From: Jake McKee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 1:08 p.m.
To: CF-Talk
Subject: CFLOOP sort order
Is there an easy way to spit out the contents of a CFLOOP backwards? So
if my CFLOOP yields this:
Item 1
Item 2
Item 3
Item 4
how do I make it spit out this:
Item 4
Item 3
Item 2
Item 1
Thanks!
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
