How about an even faster way? Here's what I do...
Generate your tree structure only ONCE... then WDDX it and store it in a
caching field of the root tree ID. Then all you have to do is call out the
WDDX packet and your tree is pre-made for you... The only time you have to
call a recursive (or non-recursive) tag to formulate the tree is when a tree
element changes.
-Cameron
--------------------
Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963
> -----Original Message-----
> From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 10:28 AM
> To: CF-Talk
> Subject: RE: tree structure
>
>
> There is a non-recursive tag way to do this. However, if at all possible,
> look to the db to handle this. There's a great book by Joe Celko
> called "SQL
> for Smarties" that discusses a method called "Nested Tree Model"
> which will
> allow you to pull out data in a tree format using any standard database.
> This is much more efficient then having CF handle the tree
> creation for you.
>
> I can probably find the non-recursive tag I wrote. It basically uses a
> string sort w/a structure but it's pretty efficient. Seemed to be
> much more
> efficient then the recursive tag calling.
>
> -Dan
>
> -----Original Message-----
> From: Pete Freitag [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 1:33 AM
> To: CF-Talk
> Subject: RE: tree structure
>
> Your going to need a recursive custom tag to do this. Here is a
> quick and
> dirty way to do it...
>
> --page.cfm--
> <cf_deletetree node="234">
>
> --deletetree.cfm--
> <cfquery name="data">
> SELECT catid from tbl
> WHERE parent = #attributes.node#
> </cfquery>
> <cfif data.recordcount>
> <!--- recursive call --->
> <cf_deletetree node="#data.catid#">
> </cfif>
>
> --
> ______________________________________________
> Pete Freitag ([EMAIL PROTECTED])
> CFDEV.COM
> ColdFusion Developer Resources
> http://www.cfdev.com
>
> -----Original Message-----
> From: Anuj Gakhar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 1:02 AM
> To: CF-Talk
> Subject: tree structure
>
>
> I have got a databse table like this:
>
> catid category parent
>
> 1 auto 0
> 2 autos1 1
> 3 autos2 2
> 4 autos3 3
> 5 autos4 0
> 6 autos5 0
> 7 autos6 5
>
> and so on .....i can add and delete categories from the table from another
> template i have made...
>
> what i want is to make a tree structure of all the categories like this
>
> -->auto
> -->autos1
> -->autos2
> -->autos3
> -->autos4
> -->autos5
> -->autos6
>
> this tree structure should come dynamically and any no. of
> categories i add
> should be displayed here.
> i tried to do this but i got mixed up with cfloop and cfoutput and i dont
> have that much time to work on it....
> can anybody please help me out of this.....
> P.S There can be any no. of categories under another category ..so dont
> think that there is only one subcategory under another category.
>
> I hope i get a solution for this here
> thanks in advance...
>
>
> _________________________________________________________ Do You Yahoo!?
> Get your free @yahoo.com address at
> ttp://mail.yahoo.com
> ------------------------------------------------------
> ------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ----------
> --------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
