<%@LANGUAGE="JAVASCRIPT"%> <% var rsDept__MMColParam = "1"; if(String(Request.QueryString("Department")) != "undefined") { rsDept__MMColParam = String(Request.QueryString("Department")); } %> <% var rsDept = Server.CreateObject("ADODB.Recordset"); rsDept.ActiveConnection = MM_connDirectory_STRING; rsDept.Source = "SELECT * FROM MainDirectory WHERE HeadGuy = 'No' AND Department = '"+ rsDept__MMColParam.replace(/'/g, "''") + "' ORDER BY LastName ASC"; rsDept.CursorType = 0; rsDept.CursorLocation = 2; rsDept.LockType = 3; rsDept.Open(); var rsDept_numRows = 0; %> <% var rsHeadguy__MMColParam = "1"; if(String(Request.QueryString("Department")) != "undefined") { rsHeadguy__MMColParam = String(Request.QueryString("Department")); } %> <% var rsHeadguy = Server.CreateObject("ADODB.Recordset"); rsHeadguy.ActiveConnection = MM_connDirectory_STRING; rsHeadguy.Source = "SELECT * FROM MainDirectory WHERE HeadGuy = 'Yes' AND Department = '"+ rsHeadguy__MMColParam.replace(/'/g, "''") + "'"; rsHeadguy.CursorType = 0; rsHeadguy.CursorLocation = 2; rsHeadguy.LockType = 3; rsHeadguy.Open(); var rsHeadguy_numRows = 0; %> <% var Repeat2__numRows = -1; var Repeat2__index = 0; rsDept_numRows += Repeat2__numRows; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsHeadguy_numRows += Repeat1__numRows; %> Office Info
You are here: Homepage> Facts & Info> Employee Directory (By Department)
 

Department of Planning

Office Info

Bedford County Department of Planning
122 East Main Street
Suite G-03
Bedford, VA 24523

540/586-7616
FAX 540/586-2059

Staff

 

<% if (!rsHeadguy.EOF || !rsHeadguy.BOF) { %>
<% while ((Repeat1__numRows-- != 0) && (!rsHeadguy.EOF)) { %> <% Repeat1__index++; rsHeadguy.MoveNext(); } %>

<%=(rsHeadguy.Fields.Item("FirstName").Value) + " " %> <%=(rsHeadguy.Fields.Item("MiddleI").Value) + " " %><%=(rsHeadguy.Fields.Item("LastName").Value) + " " %> <%=(rsHeadguy.Fields.Item("Suffix").Value)%>
<%=(rsHeadguy.Fields.Item("Title").Value)%>
<%=(rsHeadguy.Fields.Item("Department").Value)%>
<%=(rsHeadguy.Fields.Item("Address1").Value)%>
<%=(rsHeadguy.Fields.Item("Address2").Value)%>
<%=(rsHeadguy.Fields.Item("City").Value) + " " %>, <%=(rsHeadguy.Fields.Item("State").Value) + " " %> <%=(rsHeadguy.Fields.Item("ZIP").Value)%>

<%=(rsHeadguy.Fields.Item("AreaCode").Value) + " " %> <%=(rsHeadguy.Fields.Item("Phone").Value)%>
<%=(rsHeadguy.Fields.Item("Extension").Value) + " " %><%=(rsHeadguy.Fields.Item("BuildingCode").Value)%>
<%=(rsHeadguy.Fields.Item("FAX").Value)%>
"><%=(rsHeadguy.Fields.Item("email1").Value)%><%=(rsHeadguy.Fields.Item("email2").Value)%>


<% } // end !rsHeadguy.EOF || !rsHeadguy.BOF %> <% if (!rsDept.EOF || !rsDept.BOF) { %> <% while ((Repeat2__numRows-- != 0) && (!rsDept.EOF)) { %>
<%=(rsDept.Fields.Item("FirstName").Value) + " " %><%=(rsDept.Fields.Item("LastName").Value)%> <%=(rsDept.Fields.Item("Suffix").Value)%>
<%=(rsDept.Fields.Item("Title").Value)%>
<%=(rsDept.Fields.Item("Department").Value)%>
<%=(rsDept.Fields.Item("Address1").Value)%>
<%=(rsDept.Fields.Item("Address2").Value)%>
<%=(rsDept.Fields.Item("City").Value)%>, <%= " " + (rsDept.Fields.Item("State").Value + " ")%> <%=(rsDept.Fields.Item("ZIP").Value)%>

<%=(rsDept.Fields.Item("AreaCode").Value) + " " %> <%=(rsDept.Fields.Item("Phone").Value) + " "%>

<%=(rsDept.Fields.Item("Extension").Value) + " "%> <%=(rsDept.Fields.Item("BuildingCode").Value)%>
<%=(rsDept.Fields.Item("FAX").Value)%>
"><%=(rsDept.Fields.Item("email1").Value)%><%=(rsDept.Fields.Item("email2").Value)%>

<% Repeat2__index++; rsDept.MoveNext(); } %> <% } // end !rsDept.EOF || !rsDept.BOF %>

 

 
Living Here| Doing Business | Visit Us | Facts & Info | Contact Us
   
If our DHTML Menu System doesn't work with your browser, kindly use this menu
This site is optimized for IE browsers 4.0+
  
<% rsDept.Close(); %> <% rsHeadguy.Close(); %>