Art.
If this is a standard parent/child table of categories, you should look at
<CFX_MakeTree> - You find it in the Tag-gallery. Or even <CFX_fMakeTree>
which is the same as <CFX_MakeTree> but displays how you sort the query. The
tag will make a tree based on all your categories.
Rgds
* Holger Lockertsen, Solutions Developer, Horisont Information Systems AS
* Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
* 23 31 03 04 / 91 83 20 51
* [EMAIL PROTECTED] http://www.horisont.no/
NB! Horisont har fått nye nummer, og mitt INTERNNUMMER er: 23 31 03 04
> -----Original Message-----
> From: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 10, 2000 4:52 PM
> To: [EMAIL PROTECTED]
> Subject: Need help reducing the number of queries
>
>
> I need to query my table to find all my categories.
>
> I output that category name and then query to find all of its
> subcategories.
>
> I output that subcategory name and then query to find all of its
> subsubcategories.
>
> I output that and then query to find all my products that are in that
> subsubcategory.
>
> I then keep going back up a level until all the cats subcats and
> subsubcats
> with products have been listed.
>
> If I have 8 categories and each category has at least 3 subcategories and
> each subcategory has at%20least 3 subsubcategories and all
> subsubcategories
> have products in them I end up with a very long time to wait for the page.
>
> Is there ANY way to do this faster with out doing a verity search
> ????!!!!
> It's killing me.
>
> The output ends up like this visual aid:)
>
> category
> subcategory
> subsubcategories
> product
> subsubcategories
> product
> subsubcategories
> product
> subcategory
> subsubcategories
> product
> subsubcategories
> product
> subsubcategories
> product
> subcategory
> subsubcategories
> product
> subsubcategories
> product
> subsubcategories
> product
> category
> subcategory
> subsubcategories
> ........
>
> Thanks
>
> Art
>
>
>
>
>
>
>
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
