Try this: -My output query is ''GotEm''
-MakeTreeSortLevel is returned by cf_MakeTree -shim.gif is a transparent gif file. -Title is a field in the returned query. Your returned query can have as many fields as you like named whatever you like. The code below multiplies the returned sort level by variables.shimwidth to give you your physical indentation on the screen. You can hardcode the shimwidth value into the expression if you like, pull it from a different db query etc. etc. HtH, --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com --------------------------------------- <cfset variables.ShimWidth=20> <table border="0" cellpadding="0" cellspacing="2"> <cfoutput query="GotEm"> <!--- change the numeric value below to adjust the amount of indentation from one level to the next. ---> <cfset variables.Temp=(variables.ShimWidth*2)*GotEm.MakeTreeSortLevel> <tr> <td> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td> <img src="shim.gif" width="#variables.Temp#" height="1" alt="" border="0"> </td> <td>#GotEm.Title#</td> </tr> </table> </td> </tr> </cfoutput> </table> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
