<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Dim rs_roosevelt Dim rs_roosevelt_cmd Dim rs_roosevelt_numRows Set rs_roosevelt_cmd = Server.CreateObject ("ADODB.Command") rs_roosevelt_cmd.ActiveConnection = MM_conn_contacts_STRING rs_roosevelt_cmd.CommandText = "SELECT * FROM tblStaffEmail WHERE School='RO' ORDER BY [Last] ASC, [First]" rs_roosevelt_cmd.Prepared = true Set rs_roosevelt = rs_roosevelt_cmd.Execute rs_roosevelt_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_roosevelt_numRows = rs_roosevelt_numRows + Repeat1__numRows %> Roosevelt Contact Info

KFCS Header 
KFCS Facebook Link KFCS Twitter Link

Roosevelt Elementary School

Joel Sauter, Principal
1125 North Eldorado Avenue
Klamath Falls, OR 97601
phone: (541) 883-4750
fax: (541) 883-4728

Staff Contact Information

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

 

 

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