Count Lines in Pages
Contents of Page: GameScoreEdit.asp
Number of Lines: 83
Last Modified: 9/2/2021 5:46:00 AM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <!-- #include FILE="include/funcs.asp" -->
0005: <%
0006: 
0007: 	ID = Request.QueryString(("ID"))
0008: 	MMRound = Request.QueryString(("MMRound"))
0009: 
0010: 	
0011: Set rs = Server.CreateObject("ADODB.Recordset")
0012: 	sqlString = "SELECT * FROM mmScores " & _
0013: 			"WHERE ID = " & ID
0014: 	rs.Open sqlString, conn, adOpenDynamic, adLockOptimistic, adCmdText
0015: 	
0016: 	If rs.EOF Then
0017: ID = 0
0018: Yr = Season
0019:     Else
0020: 		Yr = rs("Season").Value
0021:         ID = rs("ID").Value
0022:         MMRound = rs("MMRound").Value
0023:         WTeamID = rs("WTeamID").Value
0024: 		LTeamID = rs("LTeamID").Value
0025: 		WScore  = rs("WScore").Value
0026: 		LScore  = rs("LScore").Value
0027: 		WNumber = rs("WNumber").Value
0028: 		LNumber = rs("LNumber").Value
0029: 		rs.Close
0030:      End If
0031: 		
0032: %>
0033: <html>
0034: 
0035: <head>
0036: <title>March Madness Contest - Update Prize Values</title>
0037: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0038: <link href="mm.css" rel="stylesheet" type="text/css">
0039: 
0040: </head>
0041: 
0042: <body bgcolor="#FFFFFF" onLoad="document.node.M1.select()">
0043: 
0044: <form method="post" action="GameScorePost.asp?ID=<%= ID %>" name="node">
0045:   <! input type="hidden"  name="action" value="<%= action %>">
0046:   <input type="hidden" name="ID" value="<%= ID %>">
0047:   <table border="0" cellpadding="1" cellspacing="1" width="400">
0048: 	  <tr>
0049:       <td class="norm" bgcolor="#f8f8f8" align="right">Season:</td>
0050: 	  <td><input type="text" name="Season" value="<%= Yr %>" size="5"></td>
0051:     </tr>
0052:    	  <tr>
0053:       <td class="norm" bgcolor="#f8f8f8" align="right">Round:</td>
0054: 	  <td><input type="text" name="MMRound" value="<%= MMRound %>" size="5"></td>
0055:     </tr>
0056: 
0057:    	  <tr>
0058:       <td class="norm" bgcolor="#f8f8f8" align="right">Winning Team ID:</td>
0059: 	  <td class="norm"><input type="text" name="WTeamID" value="<%= WTeamID %>" size="5"> - <%= displayTeam(WTeamID) %></td>
0060:     </tr>
0061:    	  <tr>
0062:       <td class="norm" bgcolor="#f8f8f8" align="right">Winning Score:</td>
0063: 	  <td class="norm"><input type="text" name="WScore" value="<%= WScore %>" size="5"> (<%= WNumber %>)</td>
0064:     </tr>
0065:    	  <tr>
0066:       <td class="norm" bgcolor="#f8f8f8" align="right">Losing Team ID:</td>
0067: 	  <td class="norm"><input type="text" name="LTeamID" value="<%= LTeamID %>" size="5"> - <%= displayTeam(LTeamID) %></td>
0068:     </tr>
0069: 
0070: 
0071: 
0072:    	  <tr>
0073:       <td class="norm" bgcolor="#f8f8f8" align="right">Losing Score:</td>
0074: 	  <td class="norm"><input type="text" name="LScore" value="<%= LScore %>" size="5"> (<%= LNumber %>)</td>
0075:     </tr>
0076:   <tr><td></td>
0077:       <td class="norm" align="left"><input type="submit" value="Update Score" class="norm"> <input
0078:       type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0079:     </tr>
0080:   </table>
0081: </form>
0082: </body>
0083: </html>