3 Replies Latest reply on Sep 7, 2009 7:05 PM by Adam Cameron.

    (Recursively) populate cfmenu/cfmenuitem

    Paul-ish

      So I have a cfmenu that I want to populate from a database. The cfmenu will have cfmenuitems inside parent cfmenuitems. The database that stores the menu items essentially has 4 colums: an "ID" column, a "Path" column, a "DisplayText" column, and a "ParentID" column. The ParentID column contains the ID of the row the menu item should be placed under.

       

      I believe I would have to use some sort of recursive method or something as "ParentID" can point to a row that also has a "ParentID" pointing to some row (and on). Any idea how I might go about this? (Please ask for clarification if I am not being clear)