<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "iowa" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_mooseheart_STRING Recordset1.Source = "SELECT * FROM [Active Students] WHERE Association = '" + Replace(Recordset1__MMColParam, "'", "''") + "' ORDER BY Name ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> Moose - The Family Fraternity
 

 

 
 
     
 
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %>
" class="ImageBorder">

<%=(Recordset1.Fields.Item("Name").Value)%>

Birthday: <%= DoDateTime((Recordset1.Fields.Item("Birthday").Value), 1, 4105) %>
Admitted: <%= DoDateTime((Recordset1.Fields.Item("Admitted").Value), 1, 4105) %>

Sponsored By: <%=(Recordset1.Fields.Item("Sponsor").Value)%>

   

<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
 
     
   
<% Recordset1.Close() Set Recordset1 = Nothing %>