I have 4 tables - Category, SubCategory, SubCategory2 and Files.
Each of the "Category" tables are linked to one another through foreign keys,
and Files has foreign keys on all of them.
What I want to do is be able to loop through all of the entries on "Files",
displaying the relevant entries in grouped order based upon the Category,
SubCategory, SubCategory2 structure. What I envision will end up like this:
[Category] America
[SubCategory] Connecticut
[SubCategory2] City
[File] A file.doc
Another File.doc
City2
Here's a File.doc
Wyoming
None
A file doc.doc
France
Region
Paris
A file,yo.com
And so on. In short, I want to be able to display the categories in order,
with all of the subcategories that equal the category output below them, and so
on.
Any help would be greatly appreciated!
Joel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2617
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
