%@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 Football
|
|
ROSTER |
2005 SCHEDULE |
COACH | STATS
| APACHE LADIES
VOLLEYBALL 2005 |
| Whitney Carriker |
1 |
RT |
Soph |
Houston |
| Brittney Douglas |
4 |
M |
Soph |
Ft. Worth |
| Tine McHenry |
5 |
OH |
Fresh |
Texarkana |
| Erica Wise |
6 |
OH |
Soph |
Woodville |
| Veronica Ogbelde |
7 |
M |
Fresh |
Hurst |
| Amber Brooks |
8 |
M |
Soph |
Lindale |
| Ashley Campbell |
9 |
OH |
Fresh |
Tyler |
| Frances Davies |
10 |
DS |
Fresh |
Granbury |
| Cortni Brazelton |
11 |
S |
Soph |
Deer Park |
| Chesley Boswell |
12 |
RT |
Soph |
Ft. Davis |
| Carley Schick |
21 |
DS |
Soph |
Tyler |
| Haley Hatch |
22 |
S |
Fresh |
Ft. Worth |
|
|
|