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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
