<%@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 %> Padre Island Business Association
Welcome! You are logged in to PIBA LiveData!
 

Home
Members
Bulletin
Events
Contact Us

Welcome to the Padre Island Business Association!

Site & Member Management Tools:
Welcome to the administration side of the Padre Island Business Association website! Here you can view, edit, or delete members, banners or even users who can access this page.

You can also look up site traffic statistics, submit changes for site updates, and even submit info for custom email blasts.

  PIBA Site Management Tools
  Member Management
 

Submit: Website Changes | Email Blast Info

 
 
Member Stats:
Total Number:
 
<%=(rs_members_total)%>
Reg Members w Adv:
 
<%=(rs_reg_w_adv_total)%>
Reg Members w/o Adv:
 
<%=(rs_reg_wo_adv_total)%>
Reg Members w CCCC:
 
<%=(rs_reg_w_cccc_total)%>
Associate Members:
 
<%=(rs_associate_total)%>
Non-Profit Members:
 
<%=(rs_nonprofit_total)%>
Sustainer Members:
 
<%=(rs_sustainer_total)%>
 
  • Add New Member
  • Edit Member Data
  • Delete Member

  • Add Banner Ad
  • Edit Banner Ad
  • Delete Banner Ad
PIBA
 
 
PIBA

MEMBERSHIP APPLICATION
HOME
| MEMBERS | BULLETIN | EVENTS | CONTACT
Copyright © 2008. All Rights Reserved. Padre Island Business Assocation

www.padreislandbusiness.com

 

<% 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 %>