%@LANGUAGE="VBSCRIPT"%> <% Dim u12bFixtures__MMColParam u12bFixtures__MMColParam = "U-12 B" If (Request("MM_EmptyValue") <> "") Then u12bFixtures__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u12bFixtures Dim u12bFixtures_numRows Set u12bFixtures = Server.CreateObject("ADODB.Recordset") u12bFixtures.ActiveConnection = MM_WSFLwebsite_STRING u12bFixtures.Source = "SELECT * FROM qryFixtures WHERE League = '" + Replace(u12bFixtures__MMColParam, "'", "''") + "'" u12bFixtures.CursorType = 0 u12bFixtures.CursorLocation = 2 u12bFixtures.LockType = 1 u12bFixtures.Open() u12bFixtures_numRows = 0 %> <% Dim u12bResults__MMColParam u12bResults__MMColParam = "U-12 B" If (Request("MM_EmptyValue") <> "") Then u12bResults__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u12bResults Dim u12bResults_numRows Set u12bResults = Server.CreateObject("ADODB.Recordset") u12bResults.ActiveConnection = MM_WSFLwebsite_STRING u12bResults.Source = "SELECT * FROM qryResults WHERE League = '" + Replace(u12bResults__MMColParam, "'", "''") + "'" u12bResults.CursorType = 0 u12bResults.CursorLocation = 2 u12bResults.LockType = 1 u12bResults.Open() u12bResults_numRows = 0 %> <% Dim u12bTable__MMColParam u12bTable__MMColParam = "U-12 B" If (Request("MM_EmptyValue") <> "") Then u12bTable__MMColParam = Request("MM_EmptyValue") End If %> <% Dim u12bTable Dim u12bTable_numRows Set u12bTable = Server.CreateObject("ADODB.Recordset") u12bTable.ActiveConnection = MM_WSFLwebsite_STRING u12bTable.Source = "SELECT * FROM qrysub_LEAGUE WHERE League = '" + Replace(u12bTable__MMColParam, "'", "''") + "'" u12bTable.CursorType = 0 u12bTable.CursorLocation = 2 u12bTable.LockType = 1 u12bTable.Open() u12bTable_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 u12bFixtures_numRows = u12bFixtures_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 u12bResults_numRows = u12bResults_numRows + Repeat2__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = -1 Repeat3__index = 0 u12bTable_numRows = u12bTable_numRows + Repeat3__numRows %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Main Menu |
Submenu |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Waterford Schoolboys Football League
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
©
Waterford Schoolboys Football League 2004. Administration
>> |