%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="administrator" MM_authFailedURL="index.asp" MM_grantAccess=false If Session("MM_Username") <> "" Then If (false Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString() MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer) Response.Redirect(MM_authFailedURL) End If %> <% Dim rs_users Dim rs_users_numRows Set rs_users = Server.CreateObject("ADODB.Recordset") rs_users.ActiveConnection = MM_piba_STRING rs_users.Source = "SELECT * FROM users" rs_users.CursorType = 0 rs_users.CursorLocation = 2 rs_users.LockType = 1 rs_users.Open() rs_users_numRows = 0 %> <% Dim rs_members Dim rs_members_numRows Set rs_members = Server.CreateObject("ADODB.Recordset") rs_members.ActiveConnection = MM_piba_STRING rs_members.Source = "SELECT * FROM members" rs_members.CursorType = 0 rs_members.CursorLocation = 2 rs_members.LockType = 1 rs_members.Open() rs_members_numRows = 0 %> <% Dim rs_reg_w_adv__MMColParam rs_reg_w_adv__MMColParam = "Island Business w Adv" If (Request("MM_EmptyValue") <> "") Then rs_reg_w_adv__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_reg_w_adv Dim rs_reg_w_adv_numRows Set rs_reg_w_adv = Server.CreateObject("ADODB.Recordset") rs_reg_w_adv.ActiveConnection = MM_piba_STRING rs_reg_w_adv.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_reg_w_adv__MMColParam, "'", "''") + "'" rs_reg_w_adv.CursorType = 0 rs_reg_w_adv.CursorLocation = 2 rs_reg_w_adv.LockType = 1 rs_reg_w_adv.Open() rs_reg_w_adv_numRows = 0 %> <% Dim rs_reg_wo_adv__MMColParam rs_reg_wo_adv__MMColParam = "Island Business" If (Request("MM_EmptyValue") <> "") Then rs_reg_wo_adv__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_reg_wo_adv Dim rs_reg_wo_adv_numRows Set rs_reg_wo_adv = Server.CreateObject("ADODB.Recordset") rs_reg_wo_adv.ActiveConnection = MM_piba_STRING rs_reg_wo_adv.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_reg_wo_adv__MMColParam, "'", "''") + "'" rs_reg_wo_adv.CursorType = 0 rs_reg_wo_adv.CursorLocation = 2 rs_reg_wo_adv.LockType = 1 rs_reg_wo_adv.Open() rs_reg_wo_adv_numRows = 0 %> <% Dim rs_reg_w_cccc__MMColParam rs_reg_w_cccc__MMColParam = "Island Business w CCCC" If (Request("MM_EmptyValue") <> "") Then rs_reg_w_cccc__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_reg_w_cccc Dim rs_reg_w_cccc_numRows Set rs_reg_w_cccc = Server.CreateObject("ADODB.Recordset") rs_reg_w_cccc.ActiveConnection = MM_piba_STRING rs_reg_w_cccc.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_reg_w_cccc__MMColParam, "'", "''") + "'" rs_reg_w_cccc.CursorType = 0 rs_reg_w_cccc.CursorLocation = 2 rs_reg_w_cccc.LockType = 1 rs_reg_w_cccc.Open() rs_reg_w_cccc_numRows = 0 %> <% Dim rs_associate__MMColParam rs_associate__MMColParam = "Assoc Member" If (Request("MM_EmptyValue") <> "") Then rs_associate__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_associate Dim rs_associate_numRows Set rs_associate = Server.CreateObject("ADODB.Recordset") rs_associate.ActiveConnection = MM_piba_STRING rs_associate.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_associate__MMColParam, "'", "''") + "'" rs_associate.CursorType = 0 rs_associate.CursorLocation = 2 rs_associate.LockType = 1 rs_associate.Open() rs_associate_numRows = 0 %> <% Dim rs_nonprofit__MMColParam rs_nonprofit__MMColParam = "Non-Profit" If (Request("MM_EmptyValue") <> "") Then rs_nonprofit__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_nonprofit Dim rs_nonprofit_numRows Set rs_nonprofit = Server.CreateObject("ADODB.Recordset") rs_nonprofit.ActiveConnection = MM_piba_STRING rs_nonprofit.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_nonprofit__MMColParam, "'", "''") + "'" rs_nonprofit.CursorType = 0 rs_nonprofit.CursorLocation = 2 rs_nonprofit.LockType = 1 rs_nonprofit.Open() rs_nonprofit_numRows = 0 %> <% Dim rs_sustainer__MMColParam rs_sustainer__MMColParam = "Sustainer" If (Request("MM_EmptyValue") <> "") Then rs_sustainer__MMColParam = Request("MM_EmptyValue") End If %> <% Dim rs_sustainer Dim rs_sustainer_numRows Set rs_sustainer = Server.CreateObject("ADODB.Recordset") rs_sustainer.ActiveConnection = MM_piba_STRING rs_sustainer.Source = "SELECT * FROM members WHERE member_type = '" + Replace(rs_sustainer__MMColParam, "'", "''") + "'" rs_sustainer.CursorType = 0 rs_sustainer.CursorLocation = 2 rs_sustainer.LockType = 1 rs_sustainer.Open() rs_sustainer_numRows = 0 %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_members_total Dim rs_members_first Dim rs_members_last ' set the record count rs_members_total = rs_members.RecordCount ' set the number of rows displayed on this page If (rs_members_numRows < 0) Then rs_members_numRows = rs_members_total Elseif (rs_members_numRows = 0) Then rs_members_numRows = 1 End If ' set the first and last displayed record rs_members_first = 1 rs_members_last = rs_members_first + rs_members_numRows - 1 ' if we have the correct record count, check the other stats If (rs_members_total <> -1) Then If (rs_members_first > rs_members_total) Then rs_members_first = rs_members_total End If If (rs_members_last > rs_members_total) Then rs_members_last = rs_members_total End If If (rs_members_numRows > rs_members_total) Then rs_members_numRows = rs_members_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_reg_w_adv_total Dim rs_reg_w_adv_first Dim rs_reg_w_adv_last ' set the record count rs_reg_w_adv_total = rs_reg_w_adv.RecordCount ' set the number of rows displayed on this page If (rs_reg_w_adv_numRows < 0) Then rs_reg_w_adv_numRows = rs_reg_w_adv_total Elseif (rs_reg_w_adv_numRows = 0) Then rs_reg_w_adv_numRows = 1 End If ' set the first and last displayed record rs_reg_w_adv_first = 1 rs_reg_w_adv_last = rs_reg_w_adv_first + rs_reg_w_adv_numRows - 1 ' if we have the correct record count, check the other stats If (rs_reg_w_adv_total <> -1) Then If (rs_reg_w_adv_first > rs_reg_w_adv_total) Then rs_reg_w_adv_first = rs_reg_w_adv_total End If If (rs_reg_w_adv_last > rs_reg_w_adv_total) Then rs_reg_w_adv_last = rs_reg_w_adv_total End If If (rs_reg_w_adv_numRows > rs_reg_w_adv_total) Then rs_reg_w_adv_numRows = rs_reg_w_adv_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_reg_wo_adv_total Dim rs_reg_wo_adv_first Dim rs_reg_wo_adv_last ' set the record count rs_reg_wo_adv_total = rs_reg_wo_adv.RecordCount ' set the number of rows displayed on this page If (rs_reg_wo_adv_numRows < 0) Then rs_reg_wo_adv_numRows = rs_reg_wo_adv_total Elseif (rs_reg_wo_adv_numRows = 0) Then rs_reg_wo_adv_numRows = 1 End If ' set the first and last displayed record rs_reg_wo_adv_first = 1 rs_reg_wo_adv_last = rs_reg_wo_adv_first + rs_reg_wo_adv_numRows - 1 ' if we have the correct record count, check the other stats If (rs_reg_wo_adv_total <> -1) Then If (rs_reg_wo_adv_first > rs_reg_wo_adv_total) Then rs_reg_wo_adv_first = rs_reg_wo_adv_total End If If (rs_reg_wo_adv_last > rs_reg_wo_adv_total) Then rs_reg_wo_adv_last = rs_reg_wo_adv_total End If If (rs_reg_wo_adv_numRows > rs_reg_wo_adv_total) Then rs_reg_wo_adv_numRows = rs_reg_wo_adv_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_reg_w_cccc_total Dim rs_reg_w_cccc_first Dim rs_reg_w_cccc_last ' set the record count rs_reg_w_cccc_total = rs_reg_w_cccc.RecordCount ' set the number of rows displayed on this page If (rs_reg_w_cccc_numRows < 0) Then rs_reg_w_cccc_numRows = rs_reg_w_cccc_total Elseif (rs_reg_w_cccc_numRows = 0) Then rs_reg_w_cccc_numRows = 1 End If ' set the first and last displayed record rs_reg_w_cccc_first = 1 rs_reg_w_cccc_last = rs_reg_w_cccc_first + rs_reg_w_cccc_numRows - 1 ' if we have the correct record count, check the other stats If (rs_reg_w_cccc_total <> -1) Then If (rs_reg_w_cccc_first > rs_reg_w_cccc_total) Then rs_reg_w_cccc_first = rs_reg_w_cccc_total End If If (rs_reg_w_cccc_last > rs_reg_w_cccc_total) Then rs_reg_w_cccc_last = rs_reg_w_cccc_total End If If (rs_reg_w_cccc_numRows > rs_reg_w_cccc_total) Then rs_reg_w_cccc_numRows = rs_reg_w_cccc_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_associate_total Dim rs_associate_first Dim rs_associate_last ' set the record count rs_associate_total = rs_associate.RecordCount ' set the number of rows displayed on this page If (rs_associate_numRows < 0) Then rs_associate_numRows = rs_associate_total Elseif (rs_associate_numRows = 0) Then rs_associate_numRows = 1 End If ' set the first and last displayed record rs_associate_first = 1 rs_associate_last = rs_associate_first + rs_associate_numRows - 1 ' if we have the correct record count, check the other stats If (rs_associate_total <> -1) Then If (rs_associate_first > rs_associate_total) Then rs_associate_first = rs_associate_total End If If (rs_associate_last > rs_associate_total) Then rs_associate_last = rs_associate_total End If If (rs_associate_numRows > rs_associate_total) Then rs_associate_numRows = rs_associate_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_nonprofit_total Dim rs_nonprofit_first Dim rs_nonprofit_last ' set the record count rs_nonprofit_total = rs_nonprofit.RecordCount ' set the number of rows displayed on this page If (rs_nonprofit_numRows < 0) Then rs_nonprofit_numRows = rs_nonprofit_total Elseif (rs_nonprofit_numRows = 0) Then rs_nonprofit_numRows = 1 End If ' set the first and last displayed record rs_nonprofit_first = 1 rs_nonprofit_last = rs_nonprofit_first + rs_nonprofit_numRows - 1 ' if we have the correct record count, check the other stats If (rs_nonprofit_total <> -1) Then If (rs_nonprofit_first > rs_nonprofit_total) Then rs_nonprofit_first = rs_nonprofit_total End If If (rs_nonprofit_last > rs_nonprofit_total) Then rs_nonprofit_last = rs_nonprofit_total End If If (rs_nonprofit_numRows > rs_nonprofit_total) Then rs_nonprofit_numRows = rs_nonprofit_total End If End If %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rs_sustainer_total Dim rs_sustainer_first Dim rs_sustainer_last ' set the record count rs_sustainer_total = rs_sustainer.RecordCount ' set the number of rows displayed on this page If (rs_sustainer_numRows < 0) Then rs_sustainer_numRows = rs_sustainer_total Elseif (rs_sustainer_numRows = 0) Then rs_sustainer_numRows = 1 End If ' set the first and last displayed record rs_sustainer_first = 1 rs_sustainer_last = rs_sustainer_first + rs_sustainer_numRows - 1 ' if we have the correct record count, check the other stats If (rs_sustainer_total <> -1) Then If (rs_sustainer_first > rs_sustainer_total) Then rs_sustainer_first = rs_sustainer_total End If If (rs_sustainer_last > rs_sustainer_total) Then rs_sustainer_last = rs_sustainer_total End If If (rs_sustainer_numRows > rs_sustainer_total) Then rs_sustainer_numRows = rs_sustainer_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_members_total = -1) Then ' count the total records by iterating through the recordset rs_members_total=0 While (Not rs_members.EOF) rs_members_total = rs_members_total + 1 rs_members.MoveNext Wend ' reset the cursor to the beginning If (rs_members.CursorType > 0) Then rs_members.MoveFirst Else rs_members.Requery End If ' set the number of rows displayed on this page If (rs_members_numRows < 0 Or rs_members_numRows > rs_members_total) Then rs_members_numRows = rs_members_total End If ' set the first and last displayed record rs_members_first = 1 rs_members_last = rs_members_first + rs_members_numRows - 1 If (rs_members_first > rs_members_total) Then rs_members_first = rs_members_total End If If (rs_members_last > rs_members_total) Then rs_members_last = rs_members_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_reg_w_adv_total = -1) Then ' count the total records by iterating through the recordset rs_reg_w_adv_total=0 While (Not rs_reg_w_adv.EOF) rs_reg_w_adv_total = rs_reg_w_adv_total + 1 rs_reg_w_adv.MoveNext Wend ' reset the cursor to the beginning If (rs_reg_w_adv.CursorType > 0) Then rs_reg_w_adv.MoveFirst Else rs_reg_w_adv.Requery End If ' set the number of rows displayed on this page If (rs_reg_w_adv_numRows < 0 Or rs_reg_w_adv_numRows > rs_reg_w_adv_total) Then rs_reg_w_adv_numRows = rs_reg_w_adv_total End If ' set the first and last displayed record rs_reg_w_adv_first = 1 rs_reg_w_adv_last = rs_reg_w_adv_first + rs_reg_w_adv_numRows - 1 If (rs_reg_w_adv_first > rs_reg_w_adv_total) Then rs_reg_w_adv_first = rs_reg_w_adv_total End If If (rs_reg_w_adv_last > rs_reg_w_adv_total) Then rs_reg_w_adv_last = rs_reg_w_adv_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_reg_wo_adv_total = -1) Then ' count the total records by iterating through the recordset rs_reg_wo_adv_total=0 While (Not rs_reg_wo_adv.EOF) rs_reg_wo_adv_total = rs_reg_wo_adv_total + 1 rs_reg_wo_adv.MoveNext Wend ' reset the cursor to the beginning If (rs_reg_wo_adv.CursorType > 0) Then rs_reg_wo_adv.MoveFirst Else rs_reg_wo_adv.Requery End If ' set the number of rows displayed on this page If (rs_reg_wo_adv_numRows < 0 Or rs_reg_wo_adv_numRows > rs_reg_wo_adv_total) Then rs_reg_wo_adv_numRows = rs_reg_wo_adv_total End If ' set the first and last displayed record rs_reg_wo_adv_first = 1 rs_reg_wo_adv_last = rs_reg_wo_adv_first + rs_reg_wo_adv_numRows - 1 If (rs_reg_wo_adv_first > rs_reg_wo_adv_total) Then rs_reg_wo_adv_first = rs_reg_wo_adv_total End If If (rs_reg_wo_adv_last > rs_reg_wo_adv_total) Then rs_reg_wo_adv_last = rs_reg_wo_adv_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_reg_w_cccc_total = -1) Then ' count the total records by iterating through the recordset rs_reg_w_cccc_total=0 While (Not rs_reg_w_cccc.EOF) rs_reg_w_cccc_total = rs_reg_w_cccc_total + 1 rs_reg_w_cccc.MoveNext Wend ' reset the cursor to the beginning If (rs_reg_w_cccc.CursorType > 0) Then rs_reg_w_cccc.MoveFirst Else rs_reg_w_cccc.Requery End If ' set the number of rows displayed on this page If (rs_reg_w_cccc_numRows < 0 Or rs_reg_w_cccc_numRows > rs_reg_w_cccc_total) Then rs_reg_w_cccc_numRows = rs_reg_w_cccc_total End If ' set the first and last displayed record rs_reg_w_cccc_first = 1 rs_reg_w_cccc_last = rs_reg_w_cccc_first + rs_reg_w_cccc_numRows - 1 If (rs_reg_w_cccc_first > rs_reg_w_cccc_total) Then rs_reg_w_cccc_first = rs_reg_w_cccc_total End If If (rs_reg_w_cccc_last > rs_reg_w_cccc_total) Then rs_reg_w_cccc_last = rs_reg_w_cccc_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_associate_total = -1) Then ' count the total records by iterating through the recordset rs_associate_total=0 While (Not rs_associate.EOF) rs_associate_total = rs_associate_total + 1 rs_associate.MoveNext Wend ' reset the cursor to the beginning If (rs_associate.CursorType > 0) Then rs_associate.MoveFirst Else rs_associate.Requery End If ' set the number of rows displayed on this page If (rs_associate_numRows < 0 Or rs_associate_numRows > rs_associate_total) Then rs_associate_numRows = rs_associate_total End If ' set the first and last displayed record rs_associate_first = 1 rs_associate_last = rs_associate_first + rs_associate_numRows - 1 If (rs_associate_first > rs_associate_total) Then rs_associate_first = rs_associate_total End If If (rs_associate_last > rs_associate_total) Then rs_associate_last = rs_associate_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_nonprofit_total = -1) Then ' count the total records by iterating through the recordset rs_nonprofit_total=0 While (Not rs_nonprofit.EOF) rs_nonprofit_total = rs_nonprofit_total + 1 rs_nonprofit.MoveNext Wend ' reset the cursor to the beginning If (rs_nonprofit.CursorType > 0) Then rs_nonprofit.MoveFirst Else rs_nonprofit.Requery End If ' set the number of rows displayed on this page If (rs_nonprofit_numRows < 0 Or rs_nonprofit_numRows > rs_nonprofit_total) Then rs_nonprofit_numRows = rs_nonprofit_total End If ' set the first and last displayed record rs_nonprofit_first = 1 rs_nonprofit_last = rs_nonprofit_first + rs_nonprofit_numRows - 1 If (rs_nonprofit_first > rs_nonprofit_total) Then rs_nonprofit_first = rs_nonprofit_total End If If (rs_nonprofit_last > rs_nonprofit_total) Then rs_nonprofit_last = rs_nonprofit_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rs_sustainer_total = -1) Then ' count the total records by iterating through the recordset rs_sustainer_total=0 While (Not rs_sustainer.EOF) rs_sustainer_total = rs_sustainer_total + 1 rs_sustainer.MoveNext Wend ' reset the cursor to the beginning If (rs_sustainer.CursorType > 0) Then rs_sustainer.MoveFirst Else rs_sustainer.Requery End If ' set the number of rows displayed on this page If (rs_sustainer_numRows < 0 Or rs_sustainer_numRows > rs_sustainer_total) Then rs_sustainer_numRows = rs_sustainer_total End If ' set the first and last displayed record rs_sustainer_first = 1 rs_sustainer_last = rs_sustainer_first + rs_sustainer_numRows - 1 If (rs_sustainer_first > rs_sustainer_total) Then rs_sustainer_first = rs_sustainer_total End If If (rs_sustainer_last > rs_sustainer_total) Then rs_sustainer_last = rs_sustainer_total End If End If %>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MEMBERSHIP APPLICATION
HOME | MEMBERS | BULLETIN | EVENTS | CONTACT
Copyright © 2008. All Rights Reserved. Padre Island Business Assocation
<% rs_users.Close() Set rs_users = Nothing %> <% rs_members.Close() Set rs_members = Nothing %> <% rs_reg_w_adv.Close() Set rs_reg_w_adv = Nothing %> <% rs_reg_wo_adv.Close() Set rs_reg_wo_adv = Nothing %> <% rs_reg_w_cccc.Close() Set rs_reg_w_cccc = Nothing %> <% rs_associate.Close() Set rs_associate = Nothing %> <% rs_nonprofit.Close() Set rs_nonprofit = Nothing %> <% rs_sustainer.Close() Set rs_sustainer = Nothing %>