%@LANGUAGE="VBSCRIPT"%> <% Dim u11bFixtures__MMColParam u11bFixtures__MMColParam = "1" If (Request.QueryString("U-11 B") <> "") Then u11bFixtures__MMColParam = Request.QueryString("U-11 B") End If %> <% Dim u11bFixtures Dim u11bFixtures_numRows Set u11bFixtures = Server.CreateObject("ADODB.Recordset") u11bFixtures.ActiveConnection = MM_WSFLwebsite_STRING u11bFixtures.Source = "SELECT * FROM qryFixtures WHERE League = '" + Replace(u11bFixtures__MMColParam, "'", "''") + "'" u11bFixtures.CursorType = 0 u11bFixtures.CursorLocation = 2 u11bFixtures.LockType = 1 u11bFixtures.Open() u11bFixtures_numRows = 0 %> <% Dim u11bResults__MMColParam u11bResults__MMColParam = "U-11 B" If (Request("MM_EmptyValue") <> "") Then u11bResults__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u11bResults Dim u11bResults_numRows Set u11bResults = Server.CreateObject("ADODB.Recordset") u11bResults.ActiveConnection = MM_WSFLwebsite_STRING u11bResults.Source = "SELECT * FROM qryResults WHERE League = '" + Replace(u11bResults__MMColParam, "'", "''") + "'" u11bResults.CursorType = 0 u11bResults.CursorLocation = 2 u11bResults.LockType = 1 u11bResults.Open() u11bResults_numRows = 0 %> <% Dim u11bTable__MMColParam u11bTable__MMColParam = "U-11 B" If (Request("MM_EmptyValue") <> "") Then u11bTable__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u11bTable Dim u11bTable_numRows Set u11bTable = Server.CreateObject("ADODB.Recordset") u11bTable.ActiveConnection = MM_WSFLwebsite_STRING u11bTable.Source = "SELECT * FROM qrysub_LEAGUE WHERE League = '" + Replace(u11bTable__MMColParam, "'", "''") + "'" u11bTable.CursorType = 0 u11bTable.CursorLocation = 2 u11bTable.LockType = 1 u11bTable.Open() u11bTable_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 u11bFixtures_numRows = u11bFixtures_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 u11bResults_numRows = u11bResults_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 u11bTable_numRows = u11bTable_numRows + Repeat3__numRows %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Main Menu |
Submenu |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Waterford Schoolboys Football League
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
©
Waterford Schoolboys Football League 2004. Administration
>> |