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