<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim q_teams__tournamenttxt q_teams__tournamenttxt = "%" If (request("selecttournament") <> "") Then q_teams__tournamenttxt = request("selecttournament") End If %> <% Dim q_teams__divisiontxt q_teams__divisiontxt = "%" If (request("selectdivision") <> "") Then q_teams__divisiontxt = request("selectdivision") End If %> <% Dim q_teams__eventtxt q_teams__eventtxt = "%" If (request("selectevent") <> "") Then q_teams__eventtxt = request("selectevent") End If %> <% Dim q_teams Dim q_teams_numRows Set q_teams = Server.CreateObject("ADODB.Recordset") q_teams.ActiveConnection = MM_WSSARemote_STRING q_teams.Source = "SELECT SelectTournament, Team_Name, Division, Event, Prelim_Time, Prelim_Place, Overall_Prelim_Place, Final_Time, Final_Place, Overall_Final_Place, First_Name_1, Last_Name_1, First_Name_2, Last_Name_2, First_Name_3, Last_Name_3, First_Name_4, Last_Name_4, First_name_5, Last_Name_5, Organization_State, Organization_Country FROM td_Team WHERE SelectTournament LIKE '" + Replace(q_teams__tournamenttxt, "'", "''") + "' AND Division LIKE '" + Replace(q_teams__divisiontxt, "'", "''") + "' AND Event LIKE '" + Replace(q_teams__eventtxt, "'", "''") + "' AND Prelim_Place is not null ORDER BY Prelim_Place" q_teams.CursorType = 0 q_teams.CursorLocation = 2 q_teams.LockType = 1 q_teams.Open() q_teams_numRows = 0 %> <% Dim q_tournament Dim q_tournament_numRows Set q_tournament = Server.CreateObject("ADODB.Recordset") q_tournament.ActiveConnection = MM_WSSARemote_STRING q_tournament.Source = "SELECT DISTINCT SelectTournament FROM td_Team ORDER BY SelectTournament DESC" q_tournament.CursorType = 0 q_tournament.CursorLocation = 2 q_tournament.LockType = 1 q_tournament.Open() q_tournament_numRows = 0 %> <% Dim q_division Dim q_division_numRows Set q_division = Server.CreateObject("ADODB.Recordset") q_division.ActiveConnection = MM_WSSARemote_STRING q_division.Source = "SELECT DISTINCT Division FROM td_Team ORDER BY Division" q_division.CursorType = 0 q_division.CursorLocation = 2 q_division.LockType = 1 q_division.Open() q_division_numRows = 0 %> <% Dim q_event Dim q_event_numRows Set q_event = Server.CreateObject("ADODB.Recordset") q_event.ActiveConnection = MM_WSSARemote_STRING q_event.Source = "SELECT DISTINCT Event FROM td_Team ORDER BY Event" q_event.CursorType = 0 q_event.CursorLocation = 2 q_event.LockType = 1 q_event.Open() q_event_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 4 Repeat1__index = 0 q_teams_numRows = q_teams_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim q_teams_total Dim q_teams_first Dim q_teams_last ' set the record count q_teams_total = q_teams.RecordCount ' set the number of rows displayed on this page If (q_teams_numRows < 0) Then q_teams_numRows = q_teams_total Elseif (q_teams_numRows = 0) Then q_teams_numRows = 1 End If ' set the first and last displayed record q_teams_first = 1 q_teams_last = q_teams_first + q_teams_numRows - 1 ' if we have the correct record count, check the other stats If (q_teams_total <> -1) Then If (q_teams_first > q_teams_total) Then q_teams_first = q_teams_total End If If (q_teams_last > q_teams_total) Then q_teams_last = q_teams_total End If If (q_teams_numRows > q_teams_total) Then q_teams_numRows = q_teams_total End If End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables Dim MM_rs Dim MM_rsCount Dim MM_size Dim MM_uniqueCol Dim MM_offset Dim MM_atTotal Dim MM_paramIsDefined Dim MM_param Dim MM_index Set MM_rs = q_teams MM_rsCount = q_teams_total MM_size = q_teams_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter MM_param = Request.QueryString("index") If (MM_param = "") Then MM_param = Request.QueryString("offset") End If If (MM_param <> "") Then MM_offset = Int(MM_param) End If ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record MM_index = 0 While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1)) MM_rs.MoveNext MM_index = MM_index + 1 Wend If (MM_rs.EOF) Then MM_offset = MM_index ' set MM_offset to the last possible record End If End If %> <% ' *** Move To Record: if we dont know the record count, check the display range If (MM_rsCount = -1) Then ' walk to the end of the display range for this page MM_index = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size)) MM_rs.MoveNext MM_index = MM_index + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = MM_index If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If End If ' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If ' move the cursor to the selected record MM_index = 0 While (Not MM_rs.EOF And MM_index < MM_offset) MM_rs.MoveNext MM_index = MM_index + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record q_teams_first = MM_offset + 1 q_teams_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (q_teams_first > MM_rsCount) Then q_teams_first = MM_rsCount End If If (q_teams_last > MM_rsCount) Then q_teams_last = MM_rsCount End If End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links Dim MM_keepMove Dim MM_moveParam Dim MM_moveFirst Dim MM_moveLast Dim MM_moveNext Dim MM_movePrev Dim MM_urlStr Dim MM_paramList Dim MM_paramIndex Dim MM_nextParam MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 1) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then MM_paramList = Split(MM_keepMove, "&") MM_keepMove = "" For MM_paramIndex = 0 To UBound(MM_paramList) MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1) If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&" End If MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = MM_urlStr & "0" MM_moveLast = MM_urlStr & "-1" MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size) If (MM_offset - MM_size < 0) Then MM_movePrev = MM_urlStr & "0" Else MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size) End If %> WSSA Results for Teams Overall
Go to the WSSA home page How to find information on this web site Go to the WSSA home page Contact WSSA
Reach WSSA by email
About the WSSA WSSA Tournaments and Events WSSA Rules and Regulations WSSA Results & Records
  Home > Results & Records > Teams Overall  
 
 
RESULTS:
Doubles Prelimaries
Doubles Finals
 
        Doubles Overall  
   

How to use the Results Finder -
Who holds the fastest times for the WSSA Teams Overall? Look it up here... It's easy!

From the drop down boxes below, SELECT a Tournament, AND a Division AND an Event (you must make a selection in all 3 drop down boxes).

CLICK on the "Search" button. The results will be displayed at the bottom of this page.

  
 
Individual Preliminaries
Individual Finals
Individual Overall
Teams Preliminaries
Teams Finals
Teams Overall
 
           
  Search Criteria:  
  Tournament  
  Division  
  Event  
     
<% If q_teams.EOF And q_teams.BOF Then %>
  No data matches your selection.  
<% End If ' end q_teams.EOF And q_teams.BOF %> <% If Not q_teams.EOF Or Not q_teams.BOF Then %> <% While ((Repeat1__numRows <> 0) AND (NOT q_teams.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 q_teams.MoveNext() Wend %>
  Results: <%=(q_teams.Fields.Item("SelectTournament").Value)%>  
  Division Event Team Overall
Preliminary Place 		Overall
Final Place		 First Name Last Name State Country
  <%=(q_teams.Fields.Item("Division").Value)%> <%=(q_teams.Fields.Item("Event").Value)%> <%=(q_teams.Fields.Item("Team_Name").Value)%> <%=(q_teams.Fields.Item("Overall_Prelim_Place").Value)%> <%=(q_teams.Fields.Item("Overall_Final_Place").Value)%> <%=(q_teams.Fields.Item("First_Name_1").Value)%> <%=(q_teams.Fields.Item("Last_Name_1").Value)%> <%=(q_teams.Fields.Item("Organization_State").Value)%> <%=(q_teams.Fields.Item("Organization_Country").Value)%>
            <%=(q_teams.Fields.Item("First_Name_2").Value)%> <%=(q_teams.Fields.Item("Last_Name_2").Value)%>    
            <%=(q_teams.Fields.Item("First_Name_3").Value)%> <%=(q_teams.Fields.Item("Last_Name_3").Value)%>    
            <%=(q_teams.Fields.Item("First_Name_4").Value)%> <%=(q_teams.Fields.Item("Last_Name_4").Value)%>    
            <%=(q_teams.Fields.Item("First_name_5").Value)%> <%=(q_teams.Fields.Item("Last_Name_5").Value)%>    
                   
  <% If MM_offset <> 0 Then %> First <% End If ' end MM_offset <> 0 %> <% If Not MM_atTotal Then %> Next <% End If ' end Not MM_atTotal %>   <% If MM_offset <> 0 Then %> Previous <% End If ' end MM_offset <> 0 %> <% If Not MM_atTotal Then %> Last <% End If ' end Not MM_atTotal %>        
                   
<% End If ' end Not q_teams.EOF Or NOT q_teams.BOF %>
     
  NOTE: All potential World, National and State/Provincial Records established at the 2006 WSSA World Sport Stacking Championships are currently under the video verification process. This process will be completed by April 24th and all records that are verified will be posted on this web site. Thanks for your patience.  
 
 
     

World Sport Stacking Association
All Content Copyright © 2002-2008 World Sport Stacking Association. Content may only be used with the written permission of the World Sport Stacking Association.

Web site: WorldSportStackingAssociation.org

Contact:
Telephone 1-303-962-5650
Fax 1-303-663-8580
Reach by email

Address:
P.O. Box 630526; Highlands Ranch, CO 80163-0526

 
     

 

<% q_teams.Close() Set q_teams = Nothing %> <% q_tournament.Close() Set q_tournament = Nothing %> <% q_division.Close() Set q_division = Nothing %> <% q_event.Close() Set q_event = Nothing %>