<%@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 %> Waterford Schoolboys Football League
Main Menu
Submenu

 Latest News
 Fixtures
 Results
 Tables
 Picture Gallery

 History
 Committee
 Clubs
 Development Squads

 Famous Players
 Links

 

Waterford Schoolboys Football League

Under 15 A League

Table

<% While ((Repeat3__numRows <> 0) AND (NOT u15aTable.EOF)) %> <% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 u15aTable.MoveNext() Wend %>
 
Pld
W
D
L
F
A
GD
Pts
<%=(u15aTable.Fields.Item("Home Team").Value)%>
<%=(u15aTable.Fields.Item("Pld").Value)%>
<%=(u15aTable.Fields.Item("W").Value)%>
<%=(u15aTable.Fields.Item("D").Value)%>
<%=(u15aTable.Fields.Item("L").Value)%>
<%=(u15aTable.Fields.Item("F").Value)%>
<%=(u15aTable.Fields.Item("A").Value)%>
<%=(u15aTable.Fields.Item("GD").Value)%>
<%=(u15aTable.Fields.Item("Pts").Value)%>

 

Pld:
W:
D:
L:
F:
A:
GD:
Pts:
Games Played
Games Won
Games Drawn
Games Lost
Goals For/Scored
Goals Against / Conceeded
Goal Difference
Points

 

Results

<% While ((Repeat2__numRows <> 0) AND (NOT u15aResults.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 u15aResults.MoveNext() Wend %>
<%=(u15aResults.Fields.Item("Home Team").Value)%>
<%=(u15aResults.Fields.Item("HomeScore").Value)%>
-
<%=(u15aResults.Fields.Item("AwayScore").Value)%> <%=(u15aResults.Fields.Item("Away Team").Value)%>

 

 

Fixtures

<% While ((Repeat1__numRows <> 0) AND (NOT u15a.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 u15a.MoveNext() Wend %>
Date
Venue
Fixture
Referee
<%=(u15a.Fields.Item("Date").Value)%>
<%=(u15a.Fields.Item("Venue").Value)%>
<%=(u15a.Fields.Item("Home Team").Value)%>
v
<%=(u15a.Fields.Item("Away Team").Value)%>
<%=(u15a.Fields.Item("Referee").Value)%>

 

 Under 11
   A   B   C   D

 Under 12
   A   B   C

 Under 13
   A   B   C

 Under 14
   A   B

 Under 15
   
A   B

 Under 16
   A   B   C

  
  
© Waterford Schoolboys Football League 2004. Administration >>
<% u15a.Close() Set u15a = Nothing %> <% u15aResults.Close() Set u15aResults = Nothing %> <% u15aTable.Close() Set u15aTable = Nothing %>