I am having troubles getting this to work. Do you happen to have a working example?
>It would probably be best to use recursion to accomplish this. Recursion >made my head hurt (a lot) the first time I tried to get my head around it as >well. The idea is to use a parent ID to link sub menu items to a "parent" >menu item and then use a custom tag that calls itself if there are any child >items. That way you don't have to mess re assigning the order of the child >items. > >Here an example of of the custom tag. > >http://coz.pastebin.com/f2ebb8901 > >Then you call the tag like so > ><CF_Menu_Top > DB_DSN="#Application.DB_DSN#" > LKP_PARENT_ID="0" > LKP_Menu_ID="#LKP_Menu_ID#" > > > >Notice that the tag call itself if there is any child items (a form of >encapsulation). > >Here is the MySQl data structure for this: > >http://coz.pastebin.com/f2ab7c9ae > >The cool thing about this is that you can have infinite levels of sub menus >as in sub menus with sub menus. I used this in conjunction with one of >Massimo Foti's menu widgets (I think... it was a long, Loooooong time ago) > >HTH > >G! > > > > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

