Thanks Chris.
The number of queries in my case is a bit high and takes about 5 seconds to
build up the whole tree. Over a network it could take longer. I was
wondering if i could make one big query at the beginning and put the content
in an array and from there, just work with the array all the time. However
when we (recursively) call MyMakeTree again... we could not pass the whole
array for it to be processed again could we? :-(
If we try to display everything the cost in number of queries and processing
time begins to be a bit high. Maybe a partial solution (like refreshing the
template everytime we click on a category) will make more sense. Hmmm....
-----Mensaje original-----
De: Chris Montgomery <[EMAIL PROTECTED]>
Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Fecha: viernes 14 de julio de 2000 7:53
Asunto: RE: Categories tree
>Francisco,
>
>There is an article on recursion at the Defusion site
>(http://www.defusion.com/articles/index.cfm?ArticleID=63) that might
>help.
>
>Chris Montgomery [EMAIL PROTECTED]
>
>Web Development & Consulting http://www.astutia.com
>Allaire Consulting Partner & NetObjects Reseller
>210-490-3249/888-745-7603 Fax 210-490-4692
>Find a Job in San Antonio http://www.sajobnet.com
>
>
>>-----Original Message-----
>>From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, July 13, 2000 1:06 PM
>>To: [EMAIL PROTECTED]
>>Subject: Categories tree
>>
>
>>Hi all,
>>
>>I don=B4t know if it=B4s just me or this is quite tricky. All
>>i want to =
>>do is what CFtree does but without using an applet do it.
>>I=B4ve got a =
>>set of categories and subcategories. Unfortunately the depth
>>of the tree =
>>is not fixed so basically we can add categories under a
>>certain category =
>>forever.
>>
>>I=B4m not aware of any single piece of CF code that uses recursive =
>>principles to achieve tasks. Tried to use a looping version of what i =
>>need instead but i just can=B4t come up with a solution to retrieve =
>>information no matter the depth of the category tree (yes,
>>it=B4s been a =
>>really bad day for me today). I=B4ve already got the code for
>>creating a =
>>nice dhtml tree but i just can=B4t find the way or sequence i need to =
>>generate the whole block of code. Something following a secuence like:
>>
>> Branch - Category 1
>> Leaf - Category 2
>> Leaf - Category 3
>> Branch - Category 4
>> Leaf - Category 5
>> Branch - Category 6
>> Leaf - Category 7
>> Leaf - Category 8
>>
>>... etc.
>>
>>Any ideas?
>>
>>TIA
>>
>>Francisco Montes
>>
>>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>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.mail-archive.com/[email protected]/
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.
