%@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; %>
Name |
Country |
<%=(corp_members.Fields.Item("Company").Value)%> |
<%=(corp_members.Fields.Item("CountryName").Value)%> |
Name |
Country |
<%=(Ind_members.Fields.Item("Company").Value)%> |
<%=(Ind_members.Fields.Item("CountryName").Value)%> |