Select * From Personnel Order by LastName Select * From Equipment "TEXT:Home" "1" "" "Link:index.cfm" "Home page" "TEXT:Login" "2" "" "Link:dsp_login.htm" "Login page" "TEXT:Logout" "2" "0" "Link:_Killsession.cfm" "Logout" "SEPARATOR:" "2" "" "" "" "TEXT:Admin item below is only visible to adminstrators" "2" "3" "open:" "" "TEXT:Admin" "2" "3" "Link:admin.htm" "For administrators only" "TEXT:Equipment" "1" "0" "OPEN:" "Equipment related items." "TEXT:Equipment List" "2" "0" "LINK:dsp_equipmentlist.cfm" "Equipment listing." "TEXT:Equipment Details for: " "2" "0" "OPEN:" "Equipment details display." "TEXT:#EquipmentName#" "3" "0" "LINK:dsp_equipmentdetail.cfm?EquipmentID=#EquipmentID#" "Details for #EquipmentName#." "SEPARATOR:" "2" "" "" "" "TEXT:Equipment menu item below is visible with operations permission" "2" "3" "open:" "" "TEXT:Add Equipment" "2" "3" "LINK:dsp_addequipment.cfm" "Add equipment to the database." "TEXT:Personnel" "1" "0" "OPEN:" "Personnel related items." "TEXT:Personnel Listing" "2" "0" "LINK:dsp_PersonnelList.cfm" "Listing of all personnel." "SEPARATOR:" "2" "" "" "" "TEXT:Personnel menu items below is visible with personnel permission" "2" "3" "open:" "" "TEXT:Add Personnel" "2" "3" "LINK:dsp_addPersonnel.cfm" "Add personnel." "TEXT:Edit Personnel" "2" "3" "OPEN:" "Listing of all personnel to edit." "TEXT:#LastName#, #firstName# " "3" "0" "LINK:dsp_PersonnelEdit.cfm?PersonnelID=#PersonnelID#" "Edit the record of #FirstName# #LastName#." "TEXT:Operations" "1" "0" "OPEN:" "Operations related items." "TEXT:Operations Item 1" "2" "0" "OPEN:" "Operations item 1." "TEXT:Operations Item 2" "2" "0" "OPEN:" "Operations item 2." "TEXT:Operations Item 3" "2" "0" "OPEN:" "Operations item 3." "TEXT:Operations Item 4" "2" "0" "OPEN:" "Operations item 4." "TEXT:Reporting" "1" "0" "OPEN:" "Reports." "TEXT:Report 1" "2" "0" "LINK:report1.htm" "Report 1" "TEXT:Report 2" "2" "0" "LINK:report1.htm" "Report 2" "TEXT:Report 3" "2" "0" "LINK:report1.htm" "Report 3" "TEXT:Report 4" "2" "0" "LINK:report1.htm" "Report 4" "TEXT:Report 5" "2" "0" "LINK:report1.htm" "Report 5" "TEXT:Report 6" "2" "0" "LINK:report1.htm" "Report 6" "TEXT:Report 7" "2" "0" "LINK:report1.htm" "Report 7"