Count Lines in Pages
Contents of Page: editregions.asp
Number of Lines: 57
Last Modified: 3/12/2023 5:13:20 PM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 	user = Request.Cookies("user")	
0006: 	ID = Request.QueryString(("ID"))
0007: 	If user = "" Then Response.Redirect("login.asp?from=editprizes.asp")
0008: 	
0009: Set rs = Server.CreateObject("ADODB.Recordset")
0010: 	sqlString = "SELECT * FROM mmRegionals " & _
0011: 			"WHERE ID = " & ID
0012: 	rs.Open sqlString, conn, adOpenDynamic, adLockOptimistic, adCmdText
0013: 	
0014: 	If rs.EOF Then
0015: ID = 0
0016: Yr = Season
0017:     Else
0018: 		Yr = rs("Season").Value
0019:         ID = rs("ID").Value
0020:         RegID = rs("Region").Value
0021: 		RegName = rs("RegionName").Value
0022: 		rs.Close
0023:      End If
0024: 		
0025: %>
0026: <html>
0027: 
0028: <head>
0029: <title>March Madness Contest - Update Region Names</title>
0030: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0031: <link href="mm.css" rel="stylesheet" type="text/css">
0032: 
0033: </head>
0034: 
0035: <body bgcolor="#FFFFFF" onLoad="document.node.RegNo.select()">
0036: 
0037: <form method="post" action="editregionspost.asp?ID=<%= ID %>" name="node">
0038:   <! input type="hidden"  name="action" value="<%= action %>">
0039:   <input type="hidden" name="ID" value="<%= ID %>">
0040:   <table border="0" cellpadding="1" cellspacing="1" width="400">
0041: 	  <tr>
0042: 	  <td class="norm" bgcolor="#f8f8f8">Season</td><td class="norm" bgcolor="#f8f8f8">Region#</td><td class="norm" bgcolor="#f8f8f8">Region Name</td>
0043: 	  </tr>
0044: 	  <tr>
0045:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="Season" value="<%= Yr %>"  style="height: 22" size="5" class="norm" align="right"></td>
0046:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="RegID" value="<%= RegID %>"  style="height: 22" size="2" class="norm" align="right"></td>
0047:       <td class="norm" bgcolor="#f8f8f8"><input type="text" name="RegName" value="<%= RegName %>"  style="height: 22" size="8" class="norm" align="right"></td>
0048:     </tr>
0049:   
0050:     <tr>
0051:       <td class="norm" align="left" colspan="4"><input type="submit" value="Update Region Name" class="norm"> <input
0052:       type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0053:     </tr>
0054:   </table>
0055: </form>
0056: </body>
0057: </html>