<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var Player = Server.CreateObject("ADODB.Recordset"); Player.ActiveConnection = MM_Basketball_STRING; Player.Source = "SELECT * FROM GameStats"; Player.CursorType = 0; Player.CursorLocation = 2; Player.LockType = 1; Player.Open(); var Player_numRows = 0; %> <% var Team = Server.CreateObject("ADODB.Recordset"); Team.ActiveConnection = MM_Basketball_STRING; Team.Source = "SELECT * FROM [Team Stats]"; Team.CursorType = 0; Team.CursorLocation = 2; Team.LockType = 1; Team.Open(); var Team_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; Player_numRows += Repeat1__numRows; %> <% var Repeat2__numRows = 10; var Repeat2__index = 0; Team_numRows += Repeat2__numRows; %> <% while ((Repeat1__numRows-- != 0) && (!Player.EOF)) { %> <% Repeat1__index++; Player.MoveNext(); } %>

StatID	PlName	Opp	Field Goal Percentage	Free Throw Percentage	Three Point Percentage	Rebounds	Assists	Turnovers	Points
<%=(Player.Fields.Item("StatID").Value)%>	<%=(Player.Fields.Item("PlName").Value)%>	<%=(Player.Fields.Item("Opp").Value)%>	<%=(Player.Fields.Item("Field Goal Percentage").Value)%>	<%=(Player.Fields.Item("Free Throw Percentage").Value)%>	<%=(Player.Fields.Item("Three Point Percentage").Value)%>	<%=(Player.Fields.Item("Rebounds").Value)%>	<%=(Player.Fields.Item("Assists").Value)%>	<%=(Player.Fields.Item("Turnovers").Value)%>	<%=(Player.Fields.Item("Points").Value)%>

 

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

TeamStatID	Opp	Opponent	Date	Field Goal Percentage	Free Throw Percentage	Three Point Percentage	Rebounds	Assists	Turnovers
<%=(Team.Fields.Item("TeamStatID").Value)%>	<%=(Team.Fields.Item("Opp").Value)%>	<%=(Team.Fields.Item("Opponent").Value)%>	<%=(Team.Fields.Item("Date").Value)%>	<%=(Team.Fields.Item("Field Goal Percentage").Value)%>	<%=(Team.Fields.Item("Free Throw Percentage").Value)%>	<%=(Team.Fields.Item("Three Point Percentage").Value)%>	<%=(Team.Fields.Item("Rebounds").Value)%>	<%=(Team.Fields.Item("Assists").Value)%>	<%=(Team.Fields.Item("Turnovers").Value)%>

<% Player.Close(); %> <% Team.Close(); %>