%@LANGUAGE="VBSCRIPT"%> <% Dim u15a__MMColParam u15a__MMColParam = "U-15 A" If (Request("MM_EmptyValue") <> "") Then u15a__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u15a Dim u15a_numRows Set u15a = Server.CreateObject("ADODB.Recordset") u15a.ActiveConnection = MM_WSFLwebsite_STRING u15a.Source = "SELECT * FROM qryFixtures WHERE League = '" + Replace(u15a__MMColParam, "'", "''") + "'" u15a.CursorType = 0 u15a.CursorLocation = 2 u15a.LockType = 1 u15a.Open() u15a_numRows = 0 %> <% Dim u15aResults__MMColParam u15aResults__MMColParam = "U-15 A" If (Request("MM_EmptyValue") <> "") Then u15aResults__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u15aResults Dim u15aResults_numRows Set u15aResults = Server.CreateObject("ADODB.Recordset") u15aResults.ActiveConnection = MM_WSFLwebsite_STRING u15aResults.Source = "SELECT * FROM qryResults WHERE League = '" + Replace(u15aResults__MMColParam, "'", "''") + "'" u15aResults.CursorType = 0 u15aResults.CursorLocation = 2 u15aResults.LockType = 1 u15aResults.Open() u15aResults_numRows = 0 %> <% Dim u15aTable__MMColParam u15aTable__MMColParam = "U-15 A" If (Request("MM_EmptyValue") <> "") Then u15aTable__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u15aTable Dim u15aTable_numRows Set u15aTable = Server.CreateObject("ADODB.Recordset") u15aTable.ActiveConnection = MM_WSFLwebsite_STRING u15aTable.Source = "SELECT * FROM qrysub_LEAGUE WHERE League = '" + Replace(u15aTable__MMColParam, "'", "''") + "'" u15aTable.CursorType = 0 u15aTable.CursorLocation = 2 u15aTable.LockType = 1 u15aTable.Open() u15aTable_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 u15a_numRows = u15a_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 u15aResults_numRows = u15aResults_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 u15aTable_numRows = u15aTable_numRows + Repeat3__numRows %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Main Menu |
Submenu |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Waterford Schoolboys Football League
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
©
Waterford Schoolboys Football League 2004. Administration
>> |