<%@LANGUAGE="JAVASCRIPT"%> <% var corp_members_cmd = Server.CreateObject ("ADODB.Command"); corp_members_cmd.ActiveConnection = MM_sanprota_logins_STRING; corp_members_cmd.CommandText = "SELECT * FROM Q_Membership_corp_all ORDER BY Company ASC"; corp_members_cmd.Prepared = true; var corp_members = corp_members_cmd.Execute(); var corp_members_numRows = 0; %> <% var Ind_members_cmd = Server.CreateObject ("ADODB.Command"); Ind_members_cmd.ActiveConnection = MM_sanprota_logins_STRING; Ind_members_cmd.CommandText = "SELECT * FROM Q_Membership_ind_all ORDER BY Company ASC"; Ind_members_cmd.Prepared = true; var Ind_members = Ind_members_cmd.Execute(); var Ind_members_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; corp_members_numRows += Repeat1__numRows; %> <% var Repeat2__numRows = -1; var Repeat2__index = 0; Ind_members_numRows += Repeat2__numRows; %> Members of PhytoTrade Africa

Membership Directory

Corporate Members

<% while ((Repeat1__numRows-- != 0) && (!corp_members.EOF)) { %> <% Repeat1__index++; corp_members.MoveNext(); } %>

Name

Country

<%=(corp_members.Fields.Item("Company").Value)%>

<%=(corp_members.Fields.Item("CountryName").Value)%>

Individual Members

<% while ((Repeat2__numRows-- != 0) && (!Ind_members.EOF)) { %> <% Repeat2__index++; Ind_members.MoveNext(); } %>

Name

Country

<%=(Ind_members.Fields.Item("Company").Value)%>

<%=(Ind_members.Fields.Item("CountryName").Value)%>

<% corp_members.Close(); %> <% Ind_members.Close(); %>