%
QMainMenu="Select menu_id, menu_name, menu_order, menu_parent, menu_display from menu Where menu_parent = 0 and menu_display = 1"
set GetMainMenu=ObjDBConn.execute(QMainMenu)
set buildmenu=ObjDBConn.execute(QMainMenu)
QMainMenudisabled="Select menu_id, menu_name, menu_order, menu_parent, menu_display from menu Where menu_parent = 0 and menu_display = 0"
set GetMainMenudisabled=ObjDBConn.execute(QMainMenudisabled)
DIM menuID
DIM submenuID
menuID = request.querystring("id")
submenuID = request.querystring("subid")
If menuID = "" Then
menuID = 1
End If
QSubMenu="Select menu_id, menu_name, menu_order, menu_parent, menu_display from menu Where menu_parent = " & cint(menuID) & "and menu_display = 1"
set GetSubMenu=ObjDBConn.execute(QSubMenu)
QSubMenudisabled="Select menu_id, menu_name, menu_order, menu_parent, menu_display from menu Where menu_parent = " & cint(menuID) & "and menu_display = 0"
set GetSubMenudisabled=ObjDBConn.execute(QSubMenudisabled)
QEmerg="Select emergID, emerg, display, updatestamp from Emergency where display=1"
set GetEmerg=ObjDBConn.execute(QEmerg)
%>