<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Dim rs_klc__MMColParam rs_klc__MMColParam = "KLC" If (Request("MM_EmptyValue") <> "") Then rs_klc__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_klc Dim rs_klc_cmd Dim rs_klc_numRows Set rs_klc_cmd = Server.CreateObject ("ADODB.Command") rs_klc_cmd.ActiveConnection = MM_conn_contacts_STRING rs_klc_cmd.CommandText = "SELECT * FROM tblStaffEmail WHERE School = ? ORDER BY [Last] ASC, [First]" rs_klc_cmd.Prepared = true rs_klc_cmd.Parameters.Append rs_klc_cmd.CreateParameter("param1", 200, 1, 255, rs_klc__MMColParam) ' adVarChar Set rs_klc = rs_klc_cmd.Execute rs_klc_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_klc_numRows = rs_klc_numRows + Repeat1__numRows %> KLC Contacts
KFCS Header KFCS Twitter Link KFCS Facebook Link

Tonie Kellom, Principal (email)
2856 Eberlein Ave
Klamath Falls, OR
phone: (541) 883-4719
fax: (541) 885-4281

Staff Contact Information

<% While ((Repeat1__numRows <> 0) AND (NOT rs_klc.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_klc.MoveNext() Wend %>
Staff Name Email Address Position

Room

<%=(rs_klc.Fields.Item("StaffName").Value)%> <%=(rs_klc.Fields.Item("email").Value)%> <%=(rs_klc.Fields.Item("Position").Value)%> <%=(rs_klc.Fields.Item("Room").Value)%>

 

 

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