Hello Gang,
This one, I have to say, eludes me. There is probably a very easy way
of doing this that I just don't see, but a little help would be awesome.
I have a list of categories from a query where I have parent-child
relationships going on, where my ID can also be associated within a
column called 'PARENT'. Something like this:
ID Name Parent_ID
1 Category A 0
2 Category B 0
3 Category A1 1
4 Category A2 1
5 Category B1 2
6 Category B2 2
7 Category A3 1
.. and so on, to be displayed like this:
Category A
Category A1
Category A2
Category A3
Category B
Category B1
Category B2
Anyways, I'm not quite sure how to handle this. Somehow I know a CFLOOP
has to come into all of this (or several)? I'd like to be able to make
this modular so that even 5 or 6 nests deep that every category in my
query would show (without, of course, getting repetitive and redundant
in coding). Any thoughts or hints?
Cheers,
S.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331170
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
