| ||
|
<% if Request.ServerVariables("url") <> "/members/members.asp" then %>
Membership Page <% end If %> Search Members Search Institutions Show ALL Members Printable Directory NEW members Membership Application CURRENT members Renewal Form WASFAA HOME |
<%Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open "wasfaamembers"
stmt = "SELECT DISTINCT allmembers.Instutition FROM [allmembers] WHERE MembershipType = 'R' ORDER BY Instutition ASC "
Set rs = conn.Execute(stmt, , adCmdText)
'rs.Open "allmembers",conn,adOpenKeySet,,adCmdTable
%>
<% dim unique%>
Regular Members by Institution <%Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") conn.Open "wasfaamembers" stmt = "SELECT DISTINCT allmembers.Instutition FROM [allmembers] WHERE MembershipType = 'A' ORDER BY Instutition ASC " Set rs = conn.Execute(stmt, , adCmdText) 'rs.Open "allmembers",conn,adOpenKeySet,,adCmdTable %> Associate Members by Institution |
|
| Copyright 2011 WASFAA | ||