menu=querynew("id,name,link,depth,sortorder", "integer,varchar,varchar,integer,integer"); queryaddrow(menu, 10); counter=1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 1, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 1, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 2, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 2, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 3, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 1, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth",2, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 3, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 2, counter); QuerySetCell(menu, "sortorder", counter, counter); counter=counter+1; QuerySetCell(menu, "id", counter, counter); QuerySetCell(menu, "name", "Home", counter); QuerySetCell(menu, "link", "/", counter); QuerySetCell(menu, "depth", 1, counter); QuerySetCell(menu, "sortorder", counter, counter); <#arguments.type#> SELECT * FROM arguments.menu WHERE id= <#arguments.type#>

#name# (Depth = #Depth#)

List Demo #createListFromQuery(menu, 'ul')#