If using Oracle you could use the START WITH / CONNECT BY functions to get the ordered list. If it's just for display, you could use LPAD with LEVEL to pad the children.
SELECT LABEL, SECTION_ID, TITLE, PARENT_ID, DESCR, TESTPLAN_ID, LPAD(LABEL,LENGTH(LABEL) + LEVEL,' ') AS DALABEL, LEVEL FROM TESTPLAN_SECTIONS ts WHERE testplan_id = <cfqueryparam cfsqltype="cf_sql_numeric" value="#url.tpid#" /> START WITH parent_id = 0 CONNECT BY PRIOR section_id = parent_id ORDER SIBLINGS BY LABEL On 8/24/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > Dunno if this helps mike, but Interakt has a DW extension for it. Free trial > I believe. > > http://www.interaktonline.com/Products/Free-Products/MXTreeMenu/Overview/ > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216159 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
