<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Dim rs_mills Dim rs_mills_cmd Dim rs_mills_numRows Set rs_mills_cmd = Server.CreateObject ("ADODB.Command") rs_mills_cmd.ActiveConnection = MM_conn_contacts_STRING rs_mills_cmd.CommandText = "SELECT * FROM tblStaffEmail WHERE School='MI' ORDER BY [Last] ASC, [First]" rs_mills_cmd.Prepared = true Set rs_mills = rs_mills_cmd.Execute rs_mills_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_mills_numRows = rs_mills_numRows + Repeat1__numRows %> Mills Contact Info KFCS Header KFCS Twitter Link KFCS Facebook Link

Mills Elementary School

Fred Bartels, Principal
520 East Main Street
Klamath Falls, OR 97601
phone: (541) 883-4754
fax: (541) 883-4775

Staff Contact Information

<% While ((Repeat1__numRows <> 0) AND (NOT rs_mills.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_mills.MoveNext() Wend %>
Staff Name Email Address Position Room Website
<%=(rs_mills.Fields.Item("StaffName").Value)%> <%=(rs_mills.Fields.Item("email").Value)%> <%=(rs_mills.Fields.Item("Position").Value)%> <%=(rs_mills.Fields.Item("Room").Value)%> <%=(rs_mills.Fields.Item("WebAddress").Value)%>

 

 

<% rs_mills.Close() Set rs_mills = Nothing %>