FrontPage Server Extensions for Windows - Conditional Formatting

This is Interesting: Free IT Magazines  
Home > Archive > FrontPage Server Extensions for Windows > April 2006 > Conditional Formatting





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Conditional Formatting
Bline

2006-04-10, 7:34 pm

First of all I am not a programmer I have no formal training so please
bear with me. I have muddled through the development of an application
using Front Page for Junior Football with much help from this and other
forums. I thank all that have provided me guidance and assistance.

Please see the following page:

http://www.inglemoorvikings.org/tes...portconfirm.asp

I have provided the code below.

My question is?

Please see the table with the Red Background. I have a User Request to
conditionally format those cells so that if the value of the variable
in a cell is = "OK" the background color = Green, Else the background
color = Red.

My ISP does not provide "Windows Sharepot Services", therefore I am
unable to get into Data View (as I understand it) and conditionally
format the cells. Is there ASP code I can add to accomplish this.
Please remember my limitations.

Thank you in advance for any assistance.

Here is the code:

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="http://www.w3.org/TR/REC-html40"
<!--#include file="db_connection.inc"-->



<% dim ProblemFlagReset
OpenDb "ijf.mdb", "Execute ProblemFlagReset"
%>

<% dim ProblemFlagSet
OpenDb "ijf.mdb", "Execute ProblemFlagSet"
%>


<% dim ProblemFlag2Reset
OpenDb "ijf.mdb", "Execute ProblemFlag2Reset"
%>

<% dim ProblemFlag2Set
OpenDb "ijf.mdb", "Execute ProblemFlag2Set"
%>



<%

if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
OpenDB "ijf.mdb", "INSERT INTO GameReportTestData1 (GameNumber,
System, Reporter, ReporterTelephoneNumber, ReporterEmail, HomeScore,
AwayScore, SubRule, Rosters, PlayersElig, Disqualfied, RuleComments,
CoachName, CoachEval, CoachComments, RefereeName, RefereeEval,
LinesmanName, LinesmanEval, LineJudgeName, LineJudgeEval, UmpireName,
UmpireEval, OfficialsComments) VALUES (" & chr(39) &
Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("System"),"'","''") & chr(39) & ", " & chr(39) &
Replace(Request.Form("Reporter"),"'","''") & chr(39) & ", " & chr(39) &
Replace(Request.Form("ReporterTelephoneNumber"),"'","''") & chr(39) &
", " & chr(39) & Replace(Request.Form("ReporterEmail"),"'","''") &
chr(39) & ", " & chr(39) & Replace(Request.Form("HomeScore"),"'","''")
& chr(39) & ", " & chr(39) &
Replace(Request.Form("AwayScore"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("SubRule"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("Rosters"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("PlayersElig"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("Disqualfied"),"'","''") & chr(39) & ",
" & chr(39) & Replace(Request.Form("RuleComments"),"'","''") & chr(39)
& ", " & chr(39) & Replace(Request.Form("CoachName"),"'","''") &
chr(39) & ", " & chr(39) & Replace(Request.Form("CoachEval"),"'","''")
& chr(39) & ", " & chr(39) &
Replace(Request.Form("CoachComments"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("RefereeName"),"'","''") & chr(39) & ",
" & chr(39) & Replace(Request.Form("RefereeEval"),"'","''") & chr(39)
& ", " & chr(39) & Replace(Request.Form("LinesmanName"),"'","''") &
chr(39) & ", " & chr(39) &
Replace(Request.Form("LinesmanEval"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("LineJudgeName"),"'","''") & chr(39) &
", " & chr(39) & Replace(Request.Form("LineJudgeEval"),"'","''") &
chr(39) & ", " & chr(39) &
Replace(Request.Form("UmpireName"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("UmpireEval"),"'","''") & chr(39) & ", "
& chr(39) & Replace(Request.Form("OfficialsComments"),"'","''") &
chr(39) & " )"

OpenDB "ijf.mdb", "INSERT INTO GameReportTestData (GameNumber,
System, Reporter, ReporterTelephoneNumber, ReporterEmail, HomeScore,
AwayScore, SubRule, Rosters, PlayersElig, Disqualfied, RuleComments,
CoachName, CoachEval, CoachComments, RefereeName, RefereeEval,
LinesmanName, LinesmanEval, LineJudgeName, LineJudgeEval, UmpireName,
UmpireEval, OfficialsComments) VALUES (" & chr(39) &
Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("System"),"'","''") & chr(39) & ", " & chr(39) &
Replace(Request.Form("Reporter"),"'","''") & chr(39) & ", " & chr(39) &
Replace(Request.Form("ReporterTelephoneNumber"),"'","''") & chr(39) &
", " & chr(39) & Replace(Request.Form("ReporterEmail"),"'","''") &
chr(39) & ", " & chr(39) & Replace(Request.Form("HomeScore"),"'","''")
& chr(39) & ", " & chr(39) &
Replace(Request.Form("AwayScore"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("SubRule"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("Rosters"),"'","''") & chr(39) & ", " & chr(39)
& Replace(Request.Form("PlayersElig"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("Disqualfied"),"'","''") & chr(39) & ",
" & chr(39) & Replace(Request.Form("RuleComments"),"'","''") & chr(39)
& ", " & chr(39) & Replace(Request.Form("CoachName"),"'","''") &
chr(39) & ", " & chr(39) & Replace(Request.Form("CoachEval"),"'","''")
& chr(39) & ", " & chr(39) &
Replace(Request.Form("CoachComments"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("RefereeName"),"'","''") & chr(39) & ",
" & chr(39) & Replace(Request.Form("RefereeEval"),"'","''") & chr(39)
& ", " & chr(39) & Replace(Request.Form("LinesmanName"),"'","''") &
chr(39) & ", " & chr(39) &
Replace(Request.Form("LinesmanEval"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("LineJudgeName"),"'","''") & chr(39) &
", " & chr(39) & Replace(Request.Form("LineJudgeEval"),"'","''") &
chr(39) & ", " & chr(39) &
Replace(Request.Form("UmpireName"),"'","''") & chr(39) & ", " &
chr(39) & Replace(Request.Form("UmpireEval"),"'","''") & chr(39) & ", "
& chr(39) & Replace(Request.Form("OfficialsComments"),"'","''") &
chr(39) & " )"
end if
%>

<%

if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
UPDATE "ijf.mdb", "Update Temp3 set System = (" & chr(39) &
Replace(Request.Form("System"),"'","''") & chr(39) & ") WHERE ID = 1"
end if
%>

<%

if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
UPDATE "ijf.mdb", "Update Temp3 set TempID = (" & chr(39) &
Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ") WHERE ID =
1"
end if
%>



<% ID = Request.Querystring ("ID")%>
<% GameNumber = Request.Querystring ("GameNumber")%>
<% System = Request.Querystring ("System")%>
<% If GameNumber <> "" Then
UPDATE "ijf.mdb", "Update Temp3 set TempID = (" & chr(39) &
Replace(Request.querystring("GameNUmber"),"'","''") & chr(39) & ")
WHERE ID = 1"
end If
%>

<% Dim System
If Request.Querystring ("System") <> "" Then
System = Request.Querystring ("System")
Update "ijf.mdb", "Update GameReportTestData Set System = (" & chr(39)
& Replace (Request.QueryString("System"),"'","''") & chr(39) & ") WHERE
ID = " & ID
end if
%>


<% Dim UmpireEval
If Request.Querystring ("UmpireEval") <> "" Then
UmpireEval = Request.Querystring ("UmpireEval")
Update "ijf.mdb", "Update GameReportTestData Set UmpireEval = (" &
chr(39) & Replace (Request.QueryString("UmpireEval"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>




<% Dim LineJudgeEval
If Request.Querystring ("LineJudgeEval") <> "" Then
LineJudgeEval = Request.Querystring ("LineJudgeEval")
Update "ijf.mdb", "Update GameReportTestData Set LineJudgeEval = (" &
chr(39) & Replace (Request.QueryString("LineJudgeEval"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>




<% Dim LinesmanEval
If Request.Querystring ("LinesmanEval") <> "" Then
LinesmanEval = Request.Querystring ("LinesmanEval")
Update "ijf.mdb", "Update GameReportTestData Set LinesmanEval = (" &
chr(39) & Replace (Request.QueryString("LinesmanEval"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>




<% Dim RefereeEval
If Request.Querystring ("RefereeEval") <> "" Then
RefereeEval = Request.Querystring ("RefereeEval")
Update "ijf.mdb", "Update GameReportTestData Set RefereeEval = (" &
chr(39) & Replace (Request.QueryString("RefereeEval"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim CoachEval
If Request.Querystring ("CoachEval") <> "" Then
CoachEval = Request.Querystring ("CoachEval")
Update "ijf.mdb", "Update GameReportTestData Set CoachEval = (" &
chr(39) & Replace (Request.QueryString("CoachEval"),"'","''") & chr(39)
& ") WHERE ID = " & ID
end if
%>




<% Dim Disqualfied
If Request.Querystring ("Disqualfied") <> "" Then
Disqualfied = Request.Querystring ("Disqualfied")
Update "ijf.mdb", "Update GameReportTestData Set Disqualfied = (" &
chr(39) & Replace (Request.QueryString("Disqualfied"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim PlayersElig
If Request.Querystring ("PlayersElig") <> "" Then
PlayersElig = Request.Querystring ("PlayersElig")
Update "ijf.mdb", "Update GameReportTestData Set PlayersElig = (" &
chr(39) & Replace (Request.QueryString("PlayersElig"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim Rosters
If Request.Querystring ("Rosters") <> "" Then
Rosters = Request.Querystring ("Rosters")
Update "ijf.mdb", "Update GameReportTestData Set Rosters = (" &
chr(39) & Replace (Request.QueryString("Rosters"),"'","''") & chr(39) &
") WHERE ID = " & ID
end if
%>




<% Dim SubRule
If Request.Querystring ("SubRule") <> "" Then
SubRule = Request.Querystring ("SubRule")
Update "ijf.mdb", "Update GameReportTestData Set SubRule = (" &
chr(39) & Replace (Request.QueryString("SubRule"),"'","''") & chr(39) &
") WHERE ID = " & ID
end if
%>




<% Dim OfficialsComments
If Request.Querystring ("OfficialsComments") <> "" Then
OfficialsComments = Request.Querystring ("OfficialsComments")
Update "ijf.mdb", "Update GameReportTestData Set OfficialsComments =
(" & chr(39) & Replace
(Request.QueryString("OfficialsComments"),"'","''") & chr(39) & ")
WHERE ID = " & ID
end if
%>


<% Dim CoachComments
If Request.Querystring ("CoachComments") <> "" Then
CoachComments = Request.Querystring ("CoachComments")
Update "ijf.mdb", "Update GameReportTestData Set CoachComments = (" &
chr(39) & Replace (Request.QueryString("CoachComments"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim RuleComments
If Request.Querystring ("RuleComments") <> "" Then
RuleComments = Request.Querystring ("RuleComments")
Update "ijf.mdb", "Update GameReportTestData Set RuleComments = (" &
chr(39) & Replace (Request.QueryString("RuleComments"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>


<% Dim UmpireName
If Request.Querystring ("UmpireName") <> "" Then
UmpireName = Request.Querystring ("UmpireName")
Update "ijf.mdb", "Update GameReportTestData Set UmpireName = (" &
chr(39) & Replace (Request.QueryString("UmpireName"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim LineJudgeName
If Request.Querystring ("LineJudgeName") <> "" Then
LineJudgeName = Request.Querystring ("LineJudgeName")
Update "ijf.mdb", "Update GameReportTestData Set LineJudgeName = (" &
chr(39) & Replace (Request.QueryString("LineJudgeName"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>



<% Dim LinesmanName
If Request.Querystring ("LinesmanName") <> "" Then
LinesmanName = Request.Querystring ("LinesmanName")
Update "ijf.mdb", "Update GameReportTestData Set LinesmanName = (" &
chr(39) & Replace (Request.QueryString("LinesmanName"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>


<% Dim RefereeName
If Request.Querystring ("RefereeName") <> "" Then
RefereeName = Request.Querystring ("RefereeName")
Update "ijf.mdb", "Update GameReportTestData Set RefereeName = (" &
chr(39) & Replace (Request.QueryString("RefereeName"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>


<% Dim CoachName
If Request.Querystring ("CoachName") <> "" Then
CoachName = Request.Querystring ("CoachName")
Update "ijf.mdb", "Update GameReportTestData Set CoachName = (" &
chr(39) & Replace (Request.QueryString("CoachName"),"'","''") & chr(39)
& ") WHERE ID = " & ID
end if
%>


<% Dim AwayScore
If Request.Querystring ("AwayScore") <> "" Then
AwayScore = Request.Querystring ("AwayScore")
Update "ijf.mdb", "Update GameReportTestData Set AwayScore = (" &
chr(39) & Replace (Request.QueryString("AwayScore"),"'","''") & chr(39)
& ") WHERE ID = " & ID
end if
%>


<% dim Id, Reporter
If Request.Querystring ("System") <> "" Then
System = Request.Querystring ("System")
GameNumber = Request.Form("TempId")
Update "ijf.mdb", "Update GameReportTestData Set System = (" & chr(39)
& Replace(Request.QueryString("System"),"'","''") & chr(39) & ") WHERE
ID = " & ID
UPDATE "ijf.mdb", "Update Temp3 set System = (" & chr(39)
& Replace(Request.querystring("System"),"'","''") & chr(39) & ") WHERE
ID = 1"
end if
%>

<%
If Request.Querystring ("Reporter") <> "" Then
System = Request.Querystring ("Reporter")
Update "ijf.mdb", "Update GameReportTestData Set Reporter = (" &
chr(39) & Replace (Request.QueryString("Reporter"),"'","''") & chr(39)
& ") WHERE ID = " & ID
end if
%>
<%
Dim ReporterTelephoneNumber
ReporterTelephoneNumber = Request.Querystring
("ReporterTelephoneNumber")
If Request.Querystring ("ReporterTelephoneNumber") <> "" Then
Update "ijf.mdb", "Update GameReportTestData Set
ReporterTelephoneNumber = (" & chr(39) & Replace
(Request.QueryString("ReporterTelephoneNumber"),"'","''") & chr(39) &
") WHERE ID = " & ID

end if
%>

<%
Dim ReporterEmail
If Request.Querystring ("ReporterEmail") <> "" Then
ReporterEmail = Request.Querystring ("ReporterEmail")
Update "ijf.mdb", "Update GameReportTestData Set ReporterEmail = (" &
chr(39) & Replace (Request.QueryString("ReporterEmail"),"'","''") &
chr(39) & ") WHERE ID = " & ID
end if
%>

<% Dim HomeScore
If Request.Querystring ("HomeScore") <> "" Then
HomeScore = Request.Querystring ("HomeScore")
Update "ijf.mdb", "Update GameReportTestData Set HomeScore = (" &
chr(39) & Replace (Request.QueryString("HomeScore"),"'","''") & chr(39)
& ") WHERE ID = " & ID
end if
%>
<%
if Request.querystring ("System") = "" then
if Request.querystring ("LineJudgeEval") = "" then
if Request.querystring ("UmpireEval") = "" then
if Request.querystring ("LinesmanEval") = "" then
if Request.querystring ("RefereeEval") = "" then
if Request.querystring ("CoachEval") = "" then
if Request.querystring ("OfficialsComments") = "" then
if Request.querystring ("CoachComments") = "" then
if Request.querystring ("RuleComments") = "" then
if Request.querystring ("LineJudgeName") = "" then
if Request.querystring ("UmpireName") = "" then
if Request.querystring ("LinesmanName") = "" then
if Request.querystring ("RefereeName") = "" then
if Request.querystring ("CoachName") = "" then
if Request.querystring ("Disqualfied") = "" then
if Request.querystring ("PlayersElig") = "" then
if Request.querystring ("Rosters") = "" then
if Request.querystring ("SubRule") = "" then
if Request.querystring ("AwayScore") = "" then
if Request.querystring ("HomeScore") = "" then
If Request.QueryString("ID") <> "" Then
ID = Request.Querystring ("ID")
Delete "ijf.mdb", "DELETE * FROM GameReportTestData WHERE ID = " &
ID

end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if
end if

%>


<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">

<title>New Page 1</title>
<script language="JavaScript">
<!--
function FP_preloadImgs() {//v1.0
var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image;
d.FP_imgs[i].src=a[i]; }
}
function FP_popUpMsg(msg) {//v1.0
alert(msg);
}
// -->
</script>
</head>

<body bgcolor="#FFFFCC" onload="FP_preloadImgs(/*url*/'gejfa.gif',
/*url*/'green.gif')"
background="../../../Test_copy(1)/brian/green.gif">

<div align="center">
<table border="1" width="90%" id="table1" bgcolor="#99CCFF">
<tr>
<td>
<p align="center">
<img border="0" src="../../../Test_copy(1)/brian/gejfa.gif" width="793"
height="133"></td>
</tr>
<tr>
<td>
<p align="center">
<b><font face="Arial" color="#FF0000" onclick="FP_popUpMsg('This is
page 4 of a 4 page report. This page is provided to allow you to make
any corrections to your report prior to submitting to your System
Representative for review. Listed below is the information captured on
page 3.\r\n\r\nTo Update a specific entry on the report go to the large
"U" located to the right of the item, click on the large "U"
and you will be directed to a new web page that will allow you to enter
correct information for that item. When you click submit you will be
returned to the Game Report Confirmation page and the item should be
corrected to reflect your input.\r\n\r\nTHE DELETE FUNCTION HAS BEEN
DISABLED TEMPORARILY. You may have circumstances where you duplicate a
report on the same game. In these situations you may delete one or more
of the reports by going to the large red "D" located all the
way to the right in the first section of the main body of the report.
Simply click on the large red "D" on the line representing
the report you want to delete. That report will be deleted, and
disappear of the screen. Be careful not to delete reports submitted
under your system name by other systems.\r\n\r\nPlease review carefully
and pay particular emphasis to providing comments when required. This
will save everyone considerable time. \r\n\r\nHave a GREAT
Season!!!\r\n')">About
this Page <font size="1"><br>
(Click for Instructions)</font><br>
Game Report Confirmation Form</font></b></p>
<form>
<p align="center"><nobr><font color="#0000FF" size="1">
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,TempID,System"
s-columntypes="3,2,202" s-dataconnection="Database5"
b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="System"
s-menuvalue="System" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Temp3"
s-displaycolumns="System" s-criteria s-order s-sql="SELECT * FROM
Temp3" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="4"
u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" preview=" &lt;span
style="color: rgb(0,0,0); background-color:
rgb(255,255,0)"&gt;Database&lt;/span&gt; " startspan
--><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Temp3"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="System"
fp_sMenuValue="System"
fp_sColTypes="&ID=3&TempID=2&System=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=4
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="62498"
--><select NAME="System" SIZE="1">
<!--webbot bot="AspInclude" clientside
u-incfile="../../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="11329" -->
<option><%=FP_FieldHTML(fp_rs,"System")%></option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="11345"
--></select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside preview=" &lt;span style="color:
rgb(0,0,0); background-color:
rgb(255,255,0)"&gt;Results&lt;/span&gt; " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --><!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,TempID,System" s-columntypes="3,2,202"
s-dataconnection="Database5" b-tableformat="FALSE" b-menuformat="TRUE"
s-menuchoice="TempID" s-menuvalue="System" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="Temp3" s-displaycolumns="TempID,System" s-criteria
s-order s-sql="SELECT * FROM Temp3" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records
returned." i-maxrecords="256" i-groupsize="0" botid="5"
u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" preview=" &lt;span
style="color: rgb(0,0,0); background-color:
rgb(255,255,0)"&gt;Database&lt;/span&gt; " startspan
--><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Temp3"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="TempID"
fp_sMenuValue="System"
fp_sColTypes="&ID=3&TempID=2&System=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=5
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="60908"
--><select NAME="GameNumber" SIZE="1">
<!--webbot bot="AspInclude" clientside
u-incfile="../../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="11329" -->
<option
VALUE="<%=FP_FieldHTML(fp_rs,"System")%>"><%=FP_FieldHTML(fp_rs,"TempID")%>
</option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="AspInclude" endspan i-checksum="11345"
--></select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside preview=" &lt;span style="color:
rgb(0,0,0); background-color:
rgb(255,255,0)"&gt;Results&lt;/span&gt; " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --></font></nobr></p>
</form>
<p align="center"><font face="Arial" size="2" color="#FF0000">(Page
4)</font></p>

<table width="100%" border="1" id="table2">
<thead>
<tr>
<th bgcolor="#00FF00" colspan="5">
Congratulations:<br>
You have successfully Input your Game Report, you may have to make
some corrections based on the criteria below. If you do not know how

to make corrections click on <font color="#FF0000">About this Page
</font>above.</th>
</tr>
<tr>
<th bgcolor="#0000FF" colspan="5">
<p class="MsoNormal"><span style="background-color:
#0000FF">&nbsp;</span><span style="color: white; background-color:
#0000FF">Your
Game Report has been reviewed in the following areas: 1) Is the
System you entered the appropriate System for one of the
participating teams,&nbsp; 2) If you reported any Rule Violations
did you
comment or provide an explanation? 3) If you evaluated&nbsp; either
the
Opposing Coach or any Official "Below Average" or
"Unacceptable" did
you provide comments or an explanation? 4) Did you report a 33 point

rule violation without providing comments or an explanation? The
results are listed below - <b>Please take appropriate action. <br>
</b></span><b><i><u><font face="Arial" color="#FFFFFF">
<span style="background-color: #0000FF">Comments are currently
limited to 255 Characters</span></font></u></i></b></th>
</tr>
<tr>
<th bgcolor="#336600"><font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">System</span></b></font></th>
<th bgcolor="#336600"><font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Rules</span></b></font></th>
<th bgcolor="#336600"><font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Coach</span></b></font></th>
<th bgcolor="#336600"><font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">Official</span></b></font></th>
<th bgcolor="#336600"><font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">Points</span></b></font></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-columntypes="202,202,202,202,202,202,202,3"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="SystemCheck" s-menuvalue="SystemCheck"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0"
b-makeform="FALSE" s-recordsource="GameReportCheck"
s-displaycolumns=" SystemCheck,RulesCheck,CoachCheck,Offici
alCheck,PointsCheck"
s-criteria s-order s-sql="SELECT * FROM GameReportCheck"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="Your Game Report passed the above test. Please review
the information for accuracy." i-maxrecords="256" i-groupsize="0"
botid="6" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE"
--><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM GameReportCheck"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=5 align=""LEFT"" width=""100%"">Your
Game Report passed the above test. Please review the information for
accuracy.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="SystemCheck"
fp_sMenuValue="SystemCheck"
fp_sColTypes="&System=202&System=202&SystemCheck=202&RulesCheck=202&CoachCheck=202&OfficialCheck=202&PointsCheck=202&Include=3&"
fp_iDisplayCols=5
fp_fCustomQuery=False
BOTID=6
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="56026" --><tr>
<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-column="SystemCheck" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;SystemCheck&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"SystemCheck")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30727"
--></span></font></b></td>
<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-column="RulesCheck" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;RulesCheck&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"RulesCheck")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30359"
--></span></font></b></td>
<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-column="CoachCheck" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;CoachCheck&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"CoachCheck")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28572"
--></span></font></b></td>
<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-column="OfficialCheck" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;OfficialCheck&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"OfficialCheck")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="32216"
--></span></font></b></td>
<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" System,System,SystemCheck,RulesCheck,Coa
chCheck,OfficialCheck,PointsCheck,Includ
e"
s-column="PointsCheck" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;PointsCheck&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"PointsCheck")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29341"
--></span></font></b></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297"
--></tbody>
</table>

<table width="100%" border="1" id="table3">
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#336600"><font color="#99CCFF" size="2">
<b><span style="background-color: #336600">Game
#</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">System</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">Reporter</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Tel.&nbsp;
Num.</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Email</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600"><font color="#99CCFF" size="2">
<b><span style="background-color: #336600">Home
</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Score</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600"><font color="#99CCFF" size="2">
<b><span style="background-color: #336600">Away&nbsp;
</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="3">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Score</span></b></font></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-columntypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,11,202"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="GameNumber" s-menuvalue="GameNumber" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="GameReportConfirmation"
s-displaycolumns=" GameNumber,System,Reporter,ReporterTelep
honeNumber,ReporterEmail,Home,HomeScore,
Away,AwayScore,ID"
s-criteria s-order s-sql="SELECT * FROM GameReportConfirmation"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="0" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE"
b-ReplaceDatabaseRegion="FALSE" --><!--#include
file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM GameReportConfirmation"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=10 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="GameNumber"
fp_sMenuValue="GameNumber"
fp_sColTypes="&ID=3&GameNumber=5&Reporter=202&ReporterTelephoneNumber=202&ReporterEmail=202&Home=202&HomeScore=202&Away=202&AwayScore=202&ptvioltaion=202&SubRule=202&Rosters=202&PlayersElig=202&Disqualfied=202&RuleComments=202&CoachName=202&CoachEval=202&
CoachComments=202&RefereeName=202&RefereeEval=202&LinesmanName=202&LinesmanEval=202&LineJudgeName=202&LineJudgeEval=202&UmpireName=202&UmpireEval=202&OfficialsComments=202&GameReviewed=202&ProblemFlag=11&System=202&"
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="15498" --><tr>
<td bgcolor="#C0C0C0"><font size="2" color="#99CCFF">
<span style="background-color: #336600">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="GameNumber" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;GameNumber&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
s-ColumnTypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,11,202"
--><%=FP_FieldVal(fp_rs,"GameNumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28356"
--></span></font></td>
<td bgcolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="System" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;System&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"System")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="17724"
--></span></font></td>
<td bgcolor="#FFFFFF"><b>
<font size="2"><span style="background-color: #FFFFFF">
<a target="_blank" href="System.asp">U</a></span></font></b></td>
<td bgcolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="Reporter" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;Reporter&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Reporter")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15884"
--></span></font></td>
<td bgcolor="#FFFFFF"><b>
<font size="2"><span style="background-color: #FFFFFF">
<a
href="ReporterName.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">U</a></span></font></b></td>
<td bgcolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="ReporterTelephoneNumber" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;ReporterTelephoneNumber&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ReporterTelephoneNumber")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="61806"
--></span></font></td>
<td bgcolor="#FFFFFF"><b>
<a
href="ReporterEmail.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font size="2"><span style="background-color:
#FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="ReporterEmail" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;ReporterEmail&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"ReporterEmail")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33486"
--></span></font></td>
<td bgcolor="#FFFFFF"><b>
<a
href="ReporterEmail.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font size="2"><span style="background-color:
#FFFFFF">U</span></font></a></b></td>
<td bgcolor="#C0C0C0"><font size="2" color="#99CCFF">
<span style="background-color: #336600">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="Home" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;Home&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5308" --></span></font></td>
<td bgcolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="HomeScore" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;HomeScore&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"HomeScore")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19995"
--></span></font></td>
<td bgcolor="#FFFFFF"><b>
<a
href="HomeScore2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font size="2"><span style="background-color:
#FFFFFF">U</span></font></a></b></td>
<td bgcolor="#C0C0C0"><font size="2" color="#99CCFF">
<span style="background-color: #336600">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="Away" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;Away&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Away")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5912" --></span></font></td>
<td bgcolor="#FFFFFF" bordercolor="#FFFFFF"><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="AwayScore" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;AwayScore&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"AwayScore")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="20599"
--></span></font></td>
<td bgcolor="#FFFFFF" bordercolor="#FFFFFF"><b>
<a
href="AwayScore2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font size="2"><span style="background-color:
#FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" bordercolor="#FFFFFF">&nbsp;</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297"
--></tbody>
</table>
<table width="100%" border="1" id="table4">
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Sub
Rule</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">Rosters</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Players
Eligible</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color:
#336600">Disqualified</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Rule
Comments</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Coach
Name</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Coach
Evaluation</span></b></font></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2">
<font color="#99CCFF" size="2"><b>
<span style="background-color: #336600">Coach
Comments</span></b></font></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-columntypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,11,202"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE"
s-recordsource="GameReportConfirmation"
s-displaycolumns=" SubRule,Rosters,PlayersElig,Disqualfied,
RuleComments,CoachName,CoachEval,CoachCo
mments,ID"
s-criteria s-order s-sql="SELECT * FROM GameReportConfirmation"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="1" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM GameReportConfirmation"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=9 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&GameNumber=5&Reporter=202&ReporterTelephoneNumber=202&ReporterEmail=202&Home=202&HomeScore=202&Away=202&AwayScore=202&SubRule=202&Rosters=202&PlayersElig=202&Disqualfied=202&RuleComments=202&CoachName=202&CoachEval=202&CoachComments=20
2&RefereeName=202&RefereeEval=202&LinesmanName=202&LinesmanEval=202&LineJudgeName=202&LineJudgeEval=202&UmpireName=202&UmpireEval=202&OfficialsComments=202&GameReviewed=202&ProblemFlag=11&System=202&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53071" --><tr>
<td bgcolor="#FFFFFF" width="5%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="SubRule" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;SubRule&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"SubRule")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="15149"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b><font color="#0000FF" size="2">
<a
href="SubRule2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></font></b></td>
<td bgcolor="#FFFFFF" width="5%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="Rosters" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;Rosters&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Rosters")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="14610"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="Rosters2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="5%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="PlayersElig" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;PlayersElig&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"PlayersElig")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29763"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="PlayersElig2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="5%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="Disqualfied" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;Disqualfied&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"Disqualfied")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28778"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="Disqualified2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="25%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="RuleComments" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;RuleComments&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
s-ColumnTypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,11,202"
--><%=FP_FieldVal(fp_rs,"RuleComments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33993"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="RuleComments2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="15%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="CoachName" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;CoachName&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"CoachName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19191"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="CoachName2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="8%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="CoachEval" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;CoachEval&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"CoachEval")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="19519"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="CoachEval2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
<td bgcolor="#FFFFFF" width="25%"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,SubRule,Rosters,PlayersElig,D
isqualfied,RuleComments,CoachName,CoachE
val,CoachComments,RefereeName,RefereeEva
l,LinesmanName,LinesmanEval,LineJudgeNam

e,LineJudgeEval,UmpireName,UmpireEval,Of
ficialsComments,GameReviewed,ProblemFlag
,System"
s-column="CoachComments" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;CoachComments&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
s-ColumnTypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,11,202"
--><%=FP_FieldVal(fp_rs,"CoachComments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="34934"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><b>
<a
href="CoachComments2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<font color="#0000FF" size="2">
<span style="background-color: #FFFFFF">U</span></font></a></b></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297"
--></tbody>
</table>
<table width="100%" border="1" id="table5">
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Referee
Name</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Referee
Evaluation</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Linesman
Name</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Linesman
Evaluation</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Line Judge
Name</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Line Judge
Evaluation</span></font></b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-columntypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,11,202"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="RefereeName" s-menuvalue="RefereeName"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0"
b-makeform="FALSE" s-recordsource="GameReportConfirmation"
s-displaycolumns=" RefereeName,RefereeEval,LinesmanName,Lin
esmanEval,LineJudgeName,LineJudgeEval,ID
"
s-criteria s-order s-sql="SELECT * FROM GameReportConfirmation"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="2" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE"
b-ReplaceDatabaseRegion="FALSE" --><!--#include
file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM GameReportConfirmation"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="RefereeName"
fp_sMenuValue="RefereeName"
fp_sColTypes="&ID=3&GameNumber=5&Reporter=202&ReporterTelephoneNumber=202&ReporterEmail=202&Home=202&HomeScore=202&Away=202&AwayScore=202&ptvioltaion=202&SubRule=202&Rosters=202&PlayersElig=202&Disqualfied=202&RuleComments=202&CoachName=202&CoachEval=202&
CoachComments=202&RefereeName=202&RefereeEval=202&LinesmanName=202&LinesmanEval=202&LineJudgeName=202&LineJudgeEval=202&UmpireName=202&UmpireEval=202&OfficialsComments=202&GameReviewed=202&ProblemFlag=11&System=202&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40445" --><tr>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="RefereeName" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;RefereeName&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"RefereeName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28778"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="RefereeName2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="RefereeEval" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;RefereeEval&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"RefereeEval")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28305"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="RefereeEval2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="LinesmanName" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;LinesmanName&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"LinesmanName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28920"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="LinesmanName2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="LinesmanEval" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;LinesmanEval&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"LinesmanEval")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="31034"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="LinesmanEval2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&Reporter='<%=FP_FieldURL(fp_rs,"Reporter")%>'&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="LineJudgeName" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;LineJudgeName&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"LineJudgeName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="31132"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="LineJudgeName2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="LineJudgeEval" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;LineJudgeEval&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"LineJudgeEval")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="30005"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="LineJudgeEval2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297"
--></tbody>
</table>
<table width="100%" border="1" id="table6">
<thead>
<tr>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Umpires
Name</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Umpire
Evaluation</span></font></b></th>
<th ALIGN="LEFT" bgcolor="#336600" colspan="2"><b>
<font size="2" color="#99CCFF">
<span style="background-color: #336600">Officials
Comments</span></font></b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-columntypes=" 3,5,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,202,202,202,
202,202,202,202,202,202,202,11,202"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="UmpireName" s-menuvalue="UmpireName" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="GameReportConfirmation"
s-displaycolumns=" UmpireName,UmpireEval,OfficialsComments,
ID"
s-criteria s-order s-sql="SELECT * FROM GameReportConfirmation"
b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
s-norecordsfound="No records returned." i-maxrecords="256"
i-groupsize="0" botid="3" u-dblib="../../../_fpclass/fpdblib.inc"
u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE"
b-ReplaceDatabaseRegion="FALSE" --><!--#include
file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM GameReportConfirmation"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="UmpireName"
fp_sMenuValue="UmpireName"
fp_sColTypes="&ID=3&GameNumber=5&Reporter=202&ReporterTelephoneNumber=202&ReporterEmail=202&Home=202&HomeScore=202&Away=202&AwayScore=202&ptvioltaion=202&SubRule=202&Rosters=202&PlayersElig=202&Disqualfied=202&RuleComments=202&CoachName=202&CoachEval=202&
CoachComments=202&RefereeName=202&RefereeEval=202&LinesmanName=202&LinesmanEval=202&LineJudgeName=202&LineJudgeEval=202&UmpireName=202&UmpireEval=202&OfficialsComments=202&GameReviewed=202&ProblemFlag=11&System=202&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="54153" --><tr>
<td width="15%" bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="UmpireName" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;UmpireName&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"UmpireName")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29135"
--></span></font></b></td>
<td width="2%" bgcolor="#FFFFFF"><font color="#0000FF" size="2"><b>
<a
href="UmpireName2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td width="15%" bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="UmpireEval" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;UmpireEval&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"UmpireEval")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="29791"
--></span></font></b></td>
<td width="2%" bgcolor="#FFFFFF"><font color="#0000FF" size="2"><b>
<a
href="UmpireEval2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
<td bgcolor="#FFFFFF"><b><font size="2">
<span style="background-color: #FFFFFF">
<!--webbot bot="DatabaseResultColumn"
s-columnnames=" ID,GameNumber,Reporter,ReporterTelephone
Number,ReporterEmail,Home,HomeScore,Away
,AwayScore,ptvioltaion,SubRule,Rosters,P
layersElig,Disqualfied,RuleComments,Coac
hName,CoachEval,CoachComments,RefereeNam
e,RefereeEval,LinesmanName,LinesmanEval,

LineJudgeName,LineJudgeEval,UmpireName,U
mpireEval,OfficialsComments,GameReviewed
,ProblemFlag,System"
s-column="OfficialsComments" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size="-1"&gt;&lt;&lt;&lt;/font&gt;OfficialsComments&lt;font
size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan
--><%=FP_FieldVal(fp_rs,"OfficialsComments")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="42865"
--></span></font></b></td>
<td bgcolor="#FFFFFF" width="2%"><font color="#0000FF" size="2"><b>
<a
href="OfficialsComments2.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>&GameNumber=<%=FP_FieldURL(fp_rs,"GameNumber")%>&System=<%=FP_FieldURL(fp_rs,"System")%>">
<span style="background-color: #FFFFFF">U</span></a></b></font></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td
colspan=64 bgcolor="#FFFF00"
width="100%"&gt;&lt;font color="#000000"&gt;This is
the end of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include
file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297"
--></tbody>
</table>

<div align="center">
<table border="1" width="20%" id="table7" bgcolor="#FFFFFF">
<tr>
<td>
<p align="center">
<span style="font-weight: 700; background-color: #FFFFFF">
<font color="#336600" size="2">
<a target="_blank" href="http://www.gejfa.org/">Return to
Home</a></font></span></td>
</tr>
</table>
</div>

</td>
</tr>
</table>
</div>
<p align="center">
&nbsp;</p>

</body>

</html>

Stefan B Rusynko

2006-04-10, 7:34 pm

You are using the DBRW
In Design view select each of the cells
- then switch the code view
For your first one you would have highlighted something like:

<td bgcolor="#FF0000" align="center"><b>
<font size="2" color="#FFFFFF">
<span style="background-color: #FF0000">
<!--webbot bot="DatabaseResultColumn" s-..........-->
<%=FP_FieldVal(fp_rs,"SystemCheck")%>
<!--webbot bot="DatabaseResultColumn" endspan i-checksum="30727"-->
</span></font></b></td>

Change the td tag to be conditional (below is all on 1 line)
<td bgcolor="<%=IF FP_FieldVal(fp_rs,"SystemCheck")= "OK" Then%>#008000<%Else%>#FF0000<%End If%>" align="center">

Remove the span tag
- all it does is change the background color of the text it wraps: OK

--

________________________________________
_____
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontP...53/Default.aspx
________________________________________
_____


"Bline" <billiehartline@hotmail.com> wrote in message news:1144606080.667625.145010@i39g2000cwa.googlegroups.com...
| First of all I am not a programmer I have no formal training so please
| bear with me. I have muddled through the development of an application
| using Front Page for Junior Football with much help from this and other
| forums. I thank all that have provided me guidance and assistance.
|
| Please see the following page:
|
| http://www.inglemoorvikings.org/tes...portconfirm.asp
|
| I have provided the code below.
|
| My question is?
|
| Please see the table with the Red Background. I have a User Request to
| conditionally format those cells so that if the value of the variable
| in a cell is = "OK" the background color = Green, Else the background
| color = Red.
|
| My ISP does not provide "Windows Sharepot Services", therefore I am
| unable to get into Data View (as I understand it) and conditionally
| format the cells. Is there ASP code I can add to accomplish this.
| Please remember my limitations.
|
| Thank you in advance for any assistance.
|
| Here is the code:
|
| <html xmlns:v="urn:schemas-microsoft-com:vml"
| xmlns:o="urn:schemas-microsoft-com:office:office"
| xmlns="http://www.w3.org/TR/REC-html40"
| <!--#include file="db_connection.inc"-->
|
|
|
| <% dim ProblemFlagReset
| OpenDb "ijf.mdb", "Execute ProblemFlagReset"
| %>
|
| <% dim ProblemFlagSet
| OpenDb "ijf.mdb", "Execute ProblemFlagSet"
| %>
|
|
| <% dim ProblemFlag2Reset
| OpenDb "ijf.mdb", "Execute ProblemFlag2Reset"
| %>
|
| <% dim ProblemFlag2Set
| OpenDb "ijf.mdb", "Execute ProblemFlag2Set"
| %>
|
|
|
| <%
|
| if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
| OpenDB "ijf.mdb", "INSERT INTO GameReportTestData1 (GameNumber,
| System, Reporter, ReporterTelephoneNumber, ReporterEmail, HomeScore,
| AwayScore, SubRule, Rosters, PlayersElig, Disqualfied, RuleComments,
| CoachName, CoachEval, CoachComments, RefereeName, RefereeEval,
| LinesmanName, LinesmanEval, LineJudgeName, LineJudgeEval, UmpireName,
| UmpireEval, OfficialsComments) VALUES (" & chr(39) &
| Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("System"),"'","''") & chr(39) & ", " & chr(39) &
| Replace(Request.Form("Reporter"),"'","''") & chr(39) & ", " & chr(39) &
| Replace(Request.Form("ReporterTelephoneNumber"),"'","''") & chr(39) &
| ", " & chr(39) & Replace(Request.Form("ReporterEmail"),"'","''") &
| chr(39) & ", " & chr(39) & Replace(Request.Form("HomeScore"),"'","''")
| & chr(39) & ", " & chr(39) &
| Replace(Request.Form("AwayScore"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("SubRule"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("Rosters"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("PlayersElig"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("Disqualfied"),"'","''") & chr(39) & ",
| " & chr(39) & Replace(Request.Form("RuleComments"),"'","''") & chr(39)
| & ", " & chr(39) & Replace(Request.Form("CoachName"),"'","''") &
| chr(39) & ", " & chr(39) & Replace(Request.Form("CoachEval"),"'","''")
| & chr(39) & ", " & chr(39) &
| Replace(Request.Form("CoachComments"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("RefereeName"),"'","''") & chr(39) & ",
| " & chr(39) & Replace(Request.Form("RefereeEval"),"'","''") & chr(39)
| & ", " & chr(39) & Replace(Request.Form("LinesmanName"),"'","''") &
| chr(39) & ", " & chr(39) &
| Replace(Request.Form("LinesmanEval"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("LineJudgeName"),"'","''") & chr(39) &
| ", " & chr(39) & Replace(Request.Form("LineJudgeEval"),"'","''") &
| chr(39) & ", " & chr(39) &
| Replace(Request.Form("UmpireName"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("UmpireEval"),"'","''") & chr(39) & ", "
| & chr(39) & Replace(Request.Form("OfficialsComments"),"'","''") &
| chr(39) & " )"
|
| OpenDB "ijf.mdb", "INSERT INTO GameReportTestData (GameNumber,
| System, Reporter, ReporterTelephoneNumber, ReporterEmail, HomeScore,
| AwayScore, SubRule, Rosters, PlayersElig, Disqualfied, RuleComments,
| CoachName, CoachEval, CoachComments, RefereeName, RefereeEval,
| LinesmanName, LinesmanEval, LineJudgeName, LineJudgeEval, UmpireName,
| UmpireEval, OfficialsComments) VALUES (" & chr(39) &
| Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("System"),"'","''") & chr(39) & ", " & chr(39) &
| Replace(Request.Form("Reporter"),"'","''") & chr(39) & ", " & chr(39) &
| Replace(Request.Form("ReporterTelephoneNumber"),"'","''") & chr(39) &
| ", " & chr(39) & Replace(Request.Form("ReporterEmail"),"'","''") &
| chr(39) & ", " & chr(39) & Replace(Request.Form("HomeScore"),"'","''")
| & chr(39) & ", " & chr(39) &
| Replace(Request.Form("AwayScore"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("SubRule"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("Rosters"),"'","''") & chr(39) & ", " & chr(39)
| & Replace(Request.Form("PlayersElig"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("Disqualfied"),"'","''") & chr(39) & ",
| " & chr(39) & Replace(Request.Form("RuleComments"),"'","''") & chr(39)
| & ", " & chr(39) & Replace(Request.Form("CoachName"),"'","''") &
| chr(39) & ", " & chr(39) & Replace(Request.Form("CoachEval"),"'","''")
| & chr(39) & ", " & chr(39) &
| Replace(Request.Form("CoachComments"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("RefereeName"),"'","''") & chr(39) & ",
| " & chr(39) & Replace(Request.Form("RefereeEval"),"'","''") & chr(39)
| & ", " & chr(39) & Replace(Request.Form("LinesmanName"),"'","''") &
| chr(39) & ", " & chr(39) &
| Replace(Request.Form("LinesmanEval"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("LineJudgeName"),"'","''") & chr(39) &
| ", " & chr(39) & Replace(Request.Form("LineJudgeEval"),"'","''") &
| chr(39) & ", " & chr(39) &
| Replace(Request.Form("UmpireName"),"'","''") & chr(39) & ", " &
| chr(39) & Replace(Request.Form("UmpireEval"),"'","''") & chr(39) & ", "
| & chr(39) & Replace(Request.Form("OfficialsComments"),"'","''") &
| chr(39) & " )"
| end if
| %>
|
| <%
|
| if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
| UPDATE "ijf.mdb", "Update Temp3 set System = (" & chr(39) &
| Replace(Request.Form("System"),"'","''") & chr(39) & ") WHERE ID = 1"
| end if
| %>
|
| <%
|
| if Request.ServerVariables("REQUEST_METHOD") = "POST" Then
| UPDATE "ijf.mdb", "Update Temp3 set TempID = (" & chr(39) &
| Replace(Request.Form("GameNumber"),"'","''") & chr(39) & ") WHERE ID =
| 1"
| end if
| %>
|
|
|
| <% ID = Request.Querystring ("ID")%>
| <% GameNumber = Request.Querystring ("GameNumber")%>
| <% System = Request.Querystring ("System")%>
| <% If GameNumber <> "" Then
| UPDATE "ijf.mdb", "Update Temp3 set TempID = (" & chr(39) &
| Replace(Request.querystring("GameNUmber"),"'","''") & chr(39) & ")
| WHERE ID = 1"
| end If
| %>
|
| <% Dim System
| If Request.Querystring ("System") <> "" Then
| System = Request.Querystring ("System")
| Update "ijf.mdb", "Update GameReportTestData Set System = (" & chr(39)
| & Replace (Request.QueryString("System"),"'","''") & chr(39) & ") WHERE
| ID = " & ID
| end if
| %>
|
|
| <% Dim UmpireEval
| If Request.Querystring ("UmpireEval") <> "" Then
| UmpireEval = Request.Querystring ("UmpireEval")
| Update "ijf.mdb", "Update GameReportTestData Set UmpireEval = (" &
| chr(39) & Replace (Request.QueryString("UmpireEval"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim LineJudgeEval
| If Request.Querystring ("LineJudgeEval") <> "" Then
| LineJudgeEval = Request.Querystring ("LineJudgeEval")
| Update "ijf.mdb", "Update GameReportTestData Set LineJudgeEval = (" &
| chr(39) & Replace (Request.QueryString("LineJudgeEval"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim LinesmanEval
| If Request.Querystring ("LinesmanEval") <> "" Then
| LinesmanEval = Request.Querystring ("LinesmanEval")
| Update "ijf.mdb", "Update GameReportTestData Set LinesmanEval = (" &
| chr(39) & Replace (Request.QueryString("LinesmanEval"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim RefereeEval
| If Request.Querystring ("RefereeEval") <> "" Then
| RefereeEval = Request.Querystring ("RefereeEval")
| Update "ijf.mdb", "Update GameReportTestData Set RefereeEval = (" &
| chr(39) & Replace (Request.QueryString("RefereeEval"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim CoachEval
| If Request.Querystring ("CoachEval") <> "" Then
| CoachEval = Request.Querystring ("CoachEval")
| Update "ijf.mdb", "Update GameReportTestData Set CoachEval = (" &
| chr(39) & Replace (Request.QueryString("CoachEval"),"'","''") & chr(39)
| & ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim Disqualfied
| If Request.Querystring ("Disqualfied") <> "" Then
| Disqualfied = Request.Querystring ("Disqualfied")
| Update "ijf.mdb", "Update GameReportTestData Set Disqualfied = (" &
| chr(39) & Replace (Request.QueryString("Disqualfied"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim PlayersElig
| If Request.Querystring ("PlayersElig") <> "" Then
| PlayersElig = Request.Querystring ("PlayersElig")
| Update "ijf.mdb", "Update GameReportTestData Set PlayersElig = (" &
| chr(39) & Replace (Request.QueryString("PlayersElig"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim Rosters
| If Request.Querystring ("Rosters") <> "" Then
| Rosters = Request.Querystring ("Rosters")
| Update "ijf.mdb", "Update GameReportTestData Set Rosters = (" &
| chr(39) & Replace (Request.QueryString("Rosters"),"'","''") & chr(39) &
| ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim SubRule
| If Request.Querystring ("SubRule") <> "" Then
| SubRule = Request.Querystring ("SubRule")
| Update "ijf.mdb", "Update GameReportTestData Set SubRule = (" &
| chr(39) & Replace (Request.QueryString("SubRule"),"'","''") & chr(39) &
| ") WHERE ID = " & ID
| end if
| %>
|
|
|
|
| <% Dim OfficialsComments
| If Request.Querystring ("OfficialsComments") <> "" Then
| OfficialsComments = Request.Querystring ("OfficialsComments")
| Update "ijf.mdb", "Update GameReportTestData Set OfficialsComments =
| (" & chr(39) & Replace
| (Request.QueryString("OfficialsComments"),"'","''") & chr(39) & ")
| WHERE ID = " & ID
| end if
| %>
|
|
| <% Dim CoachComments
| If Request.Querystring ("CoachComments") <> "" Then
| CoachComments = Request.Querystring ("CoachComments")
| Update "ijf.mdb", "Update GameReportTestData Set CoachComments = (" &
| chr(39) & Replace (Request.QueryString("CoachComments"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim RuleComments
| If Request.Querystring ("RuleComments") <> "" Then
| RuleComments = Request.Querystring ("RuleComments")
| Update "ijf.mdb", "Update GameReportTestData Set RuleComments = (" &
| chr(39) & Replace (Request.QueryString("RuleComments"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
| <% Dim UmpireName
| If Request.Querystring ("UmpireName") <> "" Then
| UmpireName = Request.Querystring ("UmpireName")
| Update "ijf.mdb", "Update GameReportTestData Set UmpireName = (" &
| chr(39) & Replace (Request.QueryString("UmpireName"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim LineJudgeName
| If Request.Querystring ("LineJudgeName") <> "" Then
| LineJudgeName = Request.Querystring ("LineJudgeName")
| Update "ijf.mdb", "Update GameReportTestData Set LineJudgeName = (" &
| chr(39) & Replace (Request.QueryString("LineJudgeName"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
|
| <% Dim LinesmanName
| If Request.Querystring ("LinesmanName") <> "" Then
| LinesmanName = Request.Querystring ("LinesmanName")
| Update "ijf.mdb", "Update GameReportTestData Set LinesmanName = (" &
| chr(39) & Replace (Request.QueryString("LinesmanName"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
| <% Dim RefereeName
| If Request.Querystring ("RefereeName") <> "" Then
| RefereeName = Request.Querystring ("RefereeName")
| Update "ijf.mdb", "Update GameReportTestData Set RefereeName = (" &
| chr(39) & Replace (Request.QueryString("RefereeName"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
|
| <% Dim CoachName
| If Request.Querystring ("CoachName") <> "" Then
| CoachName = Request.Querystring ("CoachName")
| Update "ijf.mdb", "Update GameReportTestData Set CoachName = (" &
| chr(39) & Replace (Request.QueryString("CoachName"),"'","''") & chr(39)
| & ") WHERE ID = " & ID
| end if
| %>
|
|
| <% Dim AwayScore
| If Request.Querystring ("AwayScore") <> "" Then
| AwayScore = Request.Querystring ("AwayScore")
| Update "ijf.mdb", "Update GameReportTestData Set AwayScore = (" &
| chr(39) & Replace (Request.QueryString("AwayScore"),"'","''") & chr(39)
| & ") WHERE ID = " & ID
| end if
| %>
|
|
| <% dim Id, Reporter
| If Request.Querystring ("System") <> "" Then
| System = Request.Querystring ("System")
| GameNumber = Request.Form("TempId")
| Update "ijf.mdb", "Update GameReportTestData Set System = (" & chr(39)
| & Replace(Request.QueryString("System"),"'","''") & chr(39) & ") WHERE
| ID = " & ID
| UPDATE "ijf.mdb", "Update Temp3 set System = (" & chr(39)
| & Replace(Request.querystring("System"),"'","''") & chr(39) & ") WHERE
| ID = 1"
| end if
| %>
|
| <%
| If Request.Querystring ("Reporter") <> "" Then
| System = Request.Querystring ("Reporter")
| Update "ijf.mdb", "Update GameReportTestData Set Reporter = (" &
| chr(39) & Replace (Request.QueryString("Reporter"),"'","''") & chr(39)
| & ") WHERE ID = " & ID
| end if
| %>
| <%
| Dim ReporterTelephoneNumber
| ReporterTelephoneNumber = Request.Querystring
| ("ReporterTelephoneNumber")
| If Request.Querystring ("ReporterTelephoneNumber") <> "" Then
| Update "ijf.mdb", "Update GameReportTestData Set
| ReporterTelephoneNumber = (" & chr(39) & Replace
| (Request.QueryString("ReporterTelephoneNumber"),"'","''") & chr(39) &
| ") WHERE ID = " & ID
|
| end if
| %>
|
| <%
| Dim ReporterEmail
| If Request.Querystring ("ReporterEmail") <> "" Then
| ReporterEmail = Request.Querystring ("ReporterEmail")
| Update "ijf.mdb", "Update GameReportTestData Set ReporterEmail = (" &
| chr(39) & Replace (Request.QueryString("ReporterEmail"),"'","''") &
| chr(39) & ") WHERE ID = " & ID
| end if
| %>
|
| <% Dim HomeScore
| If Request.Querystring ("HomeScore") <> "" Then
| HomeScore = Request.Querystring ("HomeScore")
| Update "ijf.mdb", "Update GameReportTestData Set HomeScore = (" &
| chr(39) & Replace (Request.QueryString("HomeScore"),"'","''") & chr(39)
| & ") WHERE ID = " & ID
| end if
| %>
| <%
| if Request.querystring ("System") = "" then
| if Request.querystring ("LineJudgeEval") = "" then
| if Request.querystring ("UmpireEval") = "" then
| if Request.querystring ("LinesmanEval") = "" then
| if Request.querystring ("RefereeEval") = "" then
| if Request.querystring ("CoachEval") = "" then
| if Request.querystring ("OfficialsComments") = "" then
| if Request.querystring ("CoachComments") = "" then
| if Request.querystring ("RuleComments") = "" then
| if Request.querystring ("LineJudgeName") = "" then
| if Request.querystring ("UmpireName") = "" then
| if Request.querystring ("LinesmanName") = "" then
| if Request.querystring ("RefereeName") = "" then
| if Request.querystring ("CoachName") = "" then
| if Request.querystring ("Disqualfied") = "" then
| if Request.querystring ("PlayersElig") = "" then
| if Request.querystring ("Rosters") = "" then
| if Request.querystring ("SubRule") = "" then
| if Request.querystring ("AwayScore") = "" then
| if Request.querystring ("HomeScore") = "" then
| If Request.QueryString("ID") <> "" Then
| ID = Request.Querystring ("ID")
| Delete "ijf.mdb", "DELETE * FROM GameReportTestData WHERE ID = " &
| ID
|
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
| end if
|
| %>
|
|
| <head>
| <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do
| not Edit.
| FP_CharSet = "windows-1252"
| FP_CodePage = 1252 %>
| <meta http-equiv="Content-Type" content="text/html;
| charset=windows-1252">
|
| <title>New Page 1</title>
| <script language="JavaScript">
| <!--
| function FP_preloadImgs() {//v1.0
| var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
| for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image;
| d.FP_imgs[i].src=a[i]; }
| }
| function FP_popUpMsg(msg) {//v1.0
| alert(msg);
| }
| // -->
| </script>
| </head>
|
| <body bgcolor="#FFFFCC" onload="FP_preloadImgs(/*url*/'gejfa.gif',
| /*url*/'green.gif')"
| background="../../../Test_copy(1)/brian/green.gif">
|
| <div align="center">
| <table border="1" width="90%" id="table1" bgcolor="#99CCFF">
| <tr>
| <td>
| <p align="center">
| <img border="0" src="../../../Test_copy(1)/brian/gejfa.gif" width="793"
| height="133"></td>
| </tr>
| <tr>
| <td>
| <p align="center">
| <b><font face="Arial" color="#FF0000" onclick="FP_popUpMsg('This is
| page 4 of a 4 page report. This page is provided to allow you to make
| any corrections to your report prior to submitting to your System
| Representative for review. Listed below is the information captured on
| page 3.\r\n\r\nTo Update a specific entry on the report go to the large
| "U" located to the right of the item, click on the large "U"
| and you will be directed to a new web page that will allow you to enter
| correct information for that item. When you click submit you will be
| returned to the Game Report Confirmation page and the item should be
| corrected to reflect your input.\r\n\r\nTHE DELETE FUNCTION HAS BEEN
| DISABLED TEMPORARILY. You may have circumstances where you duplicate a
| report on the same game. In these situations you may delete one or more
| of the reports by going to the large red "D" located all the
| way to the right in the first section of the main body of the report.
| Simply click on the large red "D" on the line representing
| the report you want to delete. That report will be deleted, and
| disappear of the screen. Be careful not to delete reports submitted
| under your system name by other systems.\r\n\r\nPlease review carefully
| and pay particular emphasis to providing comments when required. This
| will save everyone considerable time. \r\n\r\nHave a GREAT
| Season!!!\r\n')">About
| this Page <font size="1"><br>
| (Click for Instructions)</font><br>
| Game Report Confirmation Form</font></b></p>
| <form>
| <p align="center"><nobr><font color="#0000FF" size="1">
| <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,TempID,System"
| s-columntypes="3,2,202" s-dataconnection="Database5"
| b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="System"
| s-menuvalue="System" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| i-listformat="0" b-makeform="FALSE" s-recordsource="Temp3"
| s-displaycolumns="System" s-criteria s-order s-sql="SELECT * FROM
| Temp3" b-procedure="FALSE" clientside suggestedext="asp"
| s-defaultfields s-norecordsfound="No records returned."
| i-maxrecords="256" i-groupsize="0" botid="4"
| u-dblib="../../../_fpclass/fpdblib.inc"
| u-dbrgn1="../../../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" preview=" &lt;span
| style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)"&gt;Database&lt;/span&gt; " startspan
| --><!--#include file="../../../_fpclass/fpdblib.inc"-->
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The
| Database Results component on this page is unable to display database
| content. The page must have a filename ending in '.asp', and the web
| must be hosted on a server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="SELECT * FROM Temp3"
| fp_sDefault=""
| fp_sNoRecords="No records returned."
| fp_sDataConn="Database5"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="System"
| fp_sMenuValue="System"
| fp_sColTypes="&ID=3&TempID=2&System=202&"
| fp_iDisplayCols=1
| fp_fCustomQuery=False
| BOTID=4
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="62498"
| --><select NAME="System" SIZE="1">
| <!--webbot bot="AspInclude" clientside
| u-incfile="../../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
| file="../../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="AspInclude" endspan i-checksum="11329" -->
| <option><%=FP_FieldHTML(fp_rs,"System")%></option>
| <!--webbot bot="AspInclude" clientside
| u-incfile="../../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
| file="../../../_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="AspInclude" endspan i-checksum="11345"
| --></select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc"
| i-groupsize="0" clientside preview=" &lt;span style="color:
| rgb(0,0,0); background-color:
| rgb(255,255,0)"&gt;Results&lt;/span&gt; " startspan --><!--webbot
| bot="DatabaseRegionEnd" endspan --><!--webbot bot="DatabaseRegionStart"
|