I think i solved the problem of building the tree from the
database . . .
used the following code . . .
<cfquery name="Pull_Child" datasource="blahblah">
Select Category, ParentName
From menu
Where ParentLevel is not null
</cfquery>
<cfloop query="Pull_Child">
<cftreeitem value = "#Category#" parent = "#ParentName#"
queryAsRoot = "Main Menu" expand = "no">
</cfloop>
the table contains (Category Name - Name of a node, Parent
Name - name of the parent node, ParentLevel - level of the node in
the tree)
Now I am facing another task - analyzing the database and
outputting the correct html code for the menu . . . (if you have
any suggestions on this, please post)
Thanks to all of you for help . . .