<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "FOOT" if(Request("MM_EmptyValue") <> "") then Recordset1__MMColParam = Request("MM_EmptyValue") %> <% Dim Recordset2__MMColParam Recordset2__MMColParam = "FOOT" if(Request("MM_EmptyValue") <> "") then Recordset2__MMColParam = Request("MM_EmptyValue") %> <% set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = "dsn=dbtjcsports;" Recordset1.Source = "SELECT * FROM qryExpandedSchedule WHERE Sport = '" + Replace(Recordset1__MMColParam, "'", "''") + "' ORDER BY Expr2 ASC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open Recordset1_numRows = 0 %> <% set Recordset2 = Server.CreateObject("ADODB.Recordset") Recordset2.ActiveConnection = "dsn=dbtjcsports;" Recordset2.Source = "SELECT Sport, Name, Number, Height, Weight, Position, Class, Hometown FROM rosters WHERE Sport = '" + Replace(Recordset2__MMColParam, "'", "''") + "' ORDER BY Number ASC" Recordset2.CursorType = 0 Recordset2.CursorLocation = 2 Recordset2.LockType = 3 Recordset2.Open Recordset2_numRows = 0 %><% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %><% Dim Repeat2__numRows Repeat2__numRows = -1 Dim Repeat2__index Repeat2__index = 0 Recordset2_numRows = Recordset2_numRows + Repeat2__numRows %> Apache Soccer - Roster
 

 

 

TYLER APACHE SOCCER
2005 ROSTER
0 Rob Carroll GK Wakefield, UK
00 Devala Gorrick GK Gainesville, FL
1 Williams Freeman GK Silsbee, TX
2 Dwayne Gaynor D St. Andrew, Jamaica
3 Jean Alexander D Delray Beach, FL
4 Edmund Pietersen D Stellenbosch, SA
5 Israel Higuera F Thousand Oaks, CA
7 Avneet Shergill M Seattle, WA
8 Tony Judice F Slidell, LA
9 Gabriel Arredondo M Bryan, TX
10 Hailab Habtom M Stockholm, Sweden
11 Jermaine Johnson M St. Andrew, Jamaica
12 Reuben Moutlong F Johannesburgh, SA
13 Luis Rivas M Houston, TX
14 Juan Rodriguez F Kenner, LA
15 Matheau Hall M Virginia Beach, VA
16 Stephen Sheffield F Tyler, TX
17 Carlos Araujo M Orlando, FL
18 Carlos Romero M Kissimmee, FL
19 Karl Haggon D Peterlee Co. Durham, UK
20 Jesus Jimenez M Malaga, Spain
21 Nevojsa Opacic D Katy, TX
22 Desmond Barron M Tyler, TX