There is an article about recursion from Steve Majewski on defusion.com. I think this article answers your questions.
http://www.defusion.com/articles/index.cfm?ArticleID=63
HTH
Dominik
-----Original Message-----
From: Jake McKee [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 7:51 PM
To: CF-Talk
Subject: Recursion and Breadcrumbs
After searching high and low, I've found quite a few discussions about
using recursion to create breadcrumbs, and other nested "categorical"
info. It seems to be a pretty common question, and I would expect that
there is a common solution out there, but I can't seem to find one.
I'm trying to display:
Home > Cat > Sub Cat > Sub Sub Cat > .. Etc.
My DB table looks like :
Cat ID CatName ParentCatID
--------- ------------- -----------------
1 CDs 0
2 Good CDs 1
3 Bad CDs 1
4 U2 2
5 Nsync 3
This would display:
Home > CDs > Good CDs > U2
Anyone have a straightforward code snippet for this?
Thanks!
Jake
--
My Blog - <http://www.countersinkdg.com> www.countersinkdg.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
