if ((NOT structKeyExists(form, "theMode")) OR len(form.theMode) EQ 0) { currentPath = ''; if (structKeyExists(URL, "original_uri")) { currentPath = URL.original_uri; } else if (Len(cgi.redirect_url)) { currentPath = right(cgi.redirect_url, len(cgi.redirect_url)-1); } else if (Len(cgi.request_uri)) { currentPath = cgi.script_name & cgi.request_uri; } else if (Len(cgi.path_info)) { currentPath = cgi.path_info; } request.parmList=listlast(currentPath,"/"); form.theMode=listfirst(request.parmList,"."); if (listLen(request.parmList,".") gt 1) { form.subMode = listGetAt(request.parmList,2,"."); } } select page.*, parent.menuLabel as parentLabel, parent.urlAlias as parentAlias, parent.g1 as parentG1, parent.g2 as parentG2, parent.g3 as parentG3 from page left outer join page parent on parent.pageId = page.groupId where page.urlAlias = '#form.theMode#' and page.conType != 'l' and page.status = 1 select page.*, parent.menuLabel as parentLabel, parent.urlAlias as parentAlias, parent.g1 as parentG1, parent.g2 as parentG2, parent.g3 as parentG3 from page left outer join page parent on parent.pageId = page.groupId where page.groupId = 0 and page.status = 1 and page.seqNo > 0 order by page.seqNo limit 1 ", "all")> ", "all")> select * from category where categoryURL = '#form.subMode#' #pageTitle#
#request.mapLoader#