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=
if (query.recordcount == 1){
nextrowDepth=query.depth;
}
if (depth == previousRowDepth && depth == nextrowDepth && currentrow != 1){
writeoutput("");}
if (depth > previousRowDepth){
for(i=1; i <= #(Depth - previousRowDepth)#; i++) {
writeoutput("<#arguments.type#>");}
}
if (depth < previousRowDepth){
for(i=1; i <= #(previousRowDepth - Depth)#; i++) {
writeoutput("");
}
}
writeoutput("#name# (Depth = #Depth#)");
if (query.recordcount ==1) {
if (depth > previousrowDepth && depth >= nextrowDepth){
writeoutput("");}
if (previousRowDepth > depth && depth > nextrowDepth){
writeoutput("");}
if (nextrowDepth = depth && currentrow == 1){
writeoutput("");}
}
else if (currentrow == arguments.menu.recordcount) {
for(i=1; i <= #(previousRowDepth - Depth)#; i++) {
writeoutput("");}
}
previousRowDepth=Depth;
List Demo
#createListFromQuery(menu, 'ul')#