> Let me verify what I see in your SQL. All your categories live in the same
> table, pcategory. You give that table 3 different 'aliases' though?
I think is a self join. I do this so I can give a list of every thing and
where they fall in the category structure.
> Also it seems as though you know ahead of time that all your
> products are 3
> categories deep?
This is the way we run everything. No more than 3 clicks and no more than 3
categories deep. But you can let it go as deep as you want. Its up to you.
> This brings me to the conclusion that this SQL is used to return all the
> products that are 3 categories deep?
That is correct sir. I use this method to be able to show all categories
with all their categories with all their categories with all their products.
Wheh!
> Am I on track here Art? :)
Yes you are Jeff. : )
If you want to go as deep as you want with you categories, you are on the
right track. If you use loops and queries in the loops you will kill your
self on how long it takes to run the page. You will want to use the joins in
you SQL to make the page laod fast.
I do have to give some thanks to Dave Watts because he is the one that
helped me with this a year ago. If you need help with the queries let me
know. I do use this method all the time now.
Art
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
