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

Pelican Elementary School

Michelle McCabe, Principal
501 McLean Street
Klamath Falls, OR 97601
phone: (541) 883-4765
fax: (541) 883-4729

Staff Contact Information

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

 

 

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