<%@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 %> 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 12 B League

Table

<% While ((Repeat3__numRows <> 0) AND (NOT u12bTable.EOF)) %> <% Repeat3__index=Repeat3__index+1 Repeat3__numRows=Repeat3__numRows-1 u12bTable.MoveNext() Wend %>
Pld
W
D
L
F
A
GD
Pts
<%=(u12bTable.Fields.Item("Home Team").Value)%>
<%=(u12bTable.Fields.Item("Pld").Value)%>
<%=(u12bTable.Fields.Item("W").Value)%>
<%=(u12bTable.Fields.Item("D").Value)%>
<%=(u12bTable.Fields.Item("L").Value)%>
<%=(u12bTable.Fields.Item("F").Value)%>
<%=(u12bTable.Fields.Item("A").Value)%>
<%=(u12bTable.Fields.Item("GD").Value)%>
<%=(u12bTable.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 u12bResults.EOF)) %> <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 u12bResults.MoveNext() Wend %>
<%=(u12bResults.Fields.Item("Home Team").Value)%>
<%=(u12bResults.Fields.Item("HomeScore").Value)%>
-
<%=(u12bResults.Fields.Item("AwayScore").Value)%> <%=(u12bResults.Fields.Item("Away Team").Value)%>

 

 

Fixtures

<% While ((Repeat1__numRows <> 0) AND (NOT u12bFixtures.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 u12bFixtures.MoveNext() Wend %>
Date
Venue
Fixtures
Referee
<%=(u12bFixtures.Fields.Item("Date").Value)%>
<%=(u12bFixtures.Fields.Item("Venue").Value)%>
<%=(u12bFixtures.Fields.Item("Home Team").Value)%>
v
<%=(u12bFixtures.Fields.Item("Away Team").Value)%>
<%=(u12bFixtures.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 >>
<% u12bFixtures.Close() Set u12bFixtures = Nothing %> <% u12bResults.Close() Set u12bResults = Nothing %> <% u12bTable.Close() Set u12bTable = Nothing %>