The example query below will return an itemid (unique), parentitemid (parent
threading) and a description. The CFMODULE call will sort it (local call for
testing) and then the CFTREE code below will display it. Is this what your
looking for? (excuse the ugly code. I did it fast)

<CFQUERY name="qCategory" datasource="cf_bookmark">
    SELECT      ItemID, ParentItemID, Description
        FROM         Category
        ORDER BY  Description
</CFQUERY>

<CFmodule template="MakeTree.cfm" Query="#qCategory#" Unique="itemid"
parent="ParentItemID" Result="qSortCategory">

<cfform action="index.cfm" method="POST" enablecab="Yes">
    <cftree name="Categories" >
        <cftreeitem value="0" display="Categories">
        <CFLOOP QUERY="qSortCategory">
            <cftreeitem value="#ItemID#" display="#Description#"
parent="#ParentItemID#">
        </CFLOOP>
    </CFTREE>
</CFFORM>



> I have implemented the CF_MAKETREE tag. I would like to use the out put of
that tage to display my results like the CF_TREE does. How do I do this?
>
> ...................................
> Get your own free email account from
> http://www.popmail.com
>
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Reply via email to