Count Lines in Pages
Contents of Page: PropResultsEdit.asp
Number of Lines: 160
Last Modified: 8/22/2018 1:33:11 PM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 
0006: 	PropBetID = Trim(Request.QueryString("PropBetID"))
0007: 	Show = Trim(Request.QueryString("Show"))
0008: Dim Options(5)
0009: 		Set rs = Server.CreateObject("ADODB.Recordset")
0010: 		sqlString = "SELECT * FROM PropBets WHERE ID = " & PropBetID 
0011: 		'rs.Open sqlString, Conn, adOpenDynamic, adLockOptimistic, adCmdText
0012:  rs.Open sqlString, conn3, adOpenStatic, adLockReadOnly, adCmdText
0013:   		If rs.EOF Then
0014: 	EventID = Trim(Request.QueryString("EventID"))
0015: 	DisplayOrder = 100
0016: 	UpdateOrder = 10
0017: 	 Else
0018: 	  PropDescription = rs("PropDescription").Value
0019: Options(1) = rs("Option1").Value
0020: Options(2) = rs("Option2").Value
0021: Options(3) = rs("Option3").Value
0022: Options(4) = rs("Option4").Value
0023: Options(5) = rs("Option5").Value
0024: 
0025:       WhoWon = rs("WhoWon").Value
0026:       ActualResult = rs("ActualResult").Value
0027: 
0028:       DisplayOrder = rs("DisplayOrder").Value
0029:      End If
0030: 
0031: 			rs.Close
0032: 		Set rs = Nothing
0033: 
0034: 
0035: 
0036: %>
0037: <html>
0038: 
0039: <head>
0040: <title>PickASquare - Prop Result Update</title>
0041: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0042: <link href="admin.css" rel="stylesheet" type="text/css">
0043: 
0044: 
0045: </head>
0046: 
0047: <body bgcolor="#FFFFFF" onLoad="document.node.FirstName.select()">
0048: 
0049: <form method="post" action="PropResultsUpdate.asp?PropBetID=<% = PropBetID %>&Show=<%= Show %>" name="node"
0050: onSubmit="return checkEntry()">
0051:   <input type="hidden" name="action" value="<%= action %>"><input type="hidden" name="ID"
0052:   value="<%= ID %>"><table border="0" cellpadding="1" cellspacing="1" width="300"
0053:   align="left">
0054:     <tr>
0055:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0056: 	  <b>PropBetID:</b></font></td>
0057:       <td width="838" class="norm" bgcolor="#f8f8f8" align="left"><%= PropBetID %></td>
0058:     </tr>
0059: 
0060:      <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0061: 	  <b>DisplayOrder:</b></font></td>
0062:       <td class="norm" bgcolor="#f8f8f8" >
0063: 	  <input type="text" name="DisplayOrder" value="<%= DisplayOrder %>" style="height: 22" size="7" class="norm"></td>
0064:     </tr>	
0065:        <tr>
0066:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0067: 	  <b>PropDescription:</b></font></td>
0068:       <td class="norm" bgcolor="#f8f8f8" >
0069: 	  <input type="text" name="PropDescription" value="<%= PropDescription %>" style="height: 22" size="50" class="norm"></td>
0070:     </tr>
0071:   <tr>
0072: 	    <tr>
0073:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0074: 	  <b>Option1:</b></font></td>
0075:       <td class="norm" bgcolor="#f8f8f8" >
0076: 	  <input type="text" name="Option1" value="<%= Options(1) %>" style="height: 22" size="25" class="norm">&nbsp;&nbsp;(<%= EFirstName %>)</td>
0077:     </tr>
0078: 	    <tr>
0079:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0080: 	  <b>Option2:</b></font></td>
0081:       <td class="norm" bgcolor="#f8f8f8" >
0082: 	  <input type="text" name="Option2" value="<%= Options(2) %>" style="height: 22" size="25" class="norm">&nbsp;&nbsp;(<%= ESecondName %>)</td>
0083:     </tr>
0084: 	    <tr>
0085:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0086: 	  <b>Option3:</b></font></td>
0087:       <td class="norm" bgcolor="#f8f8f8" >
0088: 	  <input type="text" name="Option3" value="<%= Options(3) %>" style="height: 22" size="25" class="norm"></td>
0089:     </tr>
0090: 	    <tr>
0091:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0092: 	  <b>Option4:</b></font></td>
0093:       <td class="norm" bgcolor="#f8f8f8" >
0094: 	  <input type="text" name="Option4" value="<%= Options(4) %>" style="height: 22" size="25" class="norm"></td>
0095:     </tr>
0096: 	    <tr>
0097:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0098: 	  <b>Option5:</b></font></td>
0099:       <td class="norm" bgcolor="#f8f8f8" >
0100: 	  <input type="text" name="Option5" value="<%= Options(5) %>" style="height: 22" size="25" class="norm"></td>
0101:     </tr>
0102: <%
0103: If Options(1) = "" Then
0104: Options(1) = EFirstName
0105: End If
0106: If Options(2) = "" Then
0107: Options(2) = ESecondName
0108: End If
0109: WhoWonName = ""
0110: If WhoWon <> "" And WhoWon <> "L" And WhoWon <> "R" Then
0111: X = CInt(WhoWon)
0112: If X > 0 And X < 6 Then
0113: WhoWonName = Options(X)
0114: End If
0115: End If
0116: If WhoWon = "0" Then
0117: WhoWonName = "None"
0118: End If
0119: If WhoWon = "" Then
0120: WhoWonName = "Blank"
0121: End If
0122: 
0123: 
0124: %>
0125: 	<tr>
0126: 	<td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0127: 	  <b>WhoWon:</b></font></td>
0128:       <td class="norm" bgcolor="#f8f8f8" >
0129: <select name="WhoWon" size="1">
0130:         <option selected value="<%= WhoWon %>"><%= WhoWon %> - <%= WhoWonName %></option>
0131:         <option value=" ">- Blank -</option>
0132:         <option value="1">1) <%= Options(1) %></option>
0133:         <option value="2">2) <%= Options(2) %></option>
0134: <% If Options(3) <> "" Then %>
0135:         <option value="3">3) <%= Options(3) %></option>
0136: <% End If %>
0137: <% If Options(4) <> "" Then %>
0138:         <option value="4">4) <%= Options(4) %></option>
0139: <% End If %>
0140: <% If Options(5) <> "" Then %>
0141:         <option value="5">5) <%= Options(5) %></option>
0142: <% End If %>
0143:       </select>
0144:     </tr>
0145:     <tr>
0146:       <td width="208" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0147: 	  <b>Actual Result:</b></font></td>
0148:       <td class="norm" bgcolor="#f8f8f8" >
0149: 	  <input type="text" name="ActualResult" value="<%= ActualResult %>" style="height: 22" size="25" class="norm"></td>
0150:     </tr>
0151:   
0152:     <tr>
0153: <td></td>
0154:       <td class="norm" align="left" colspan="6" ><br><input type="submit" value="Update Result"
0155:       class="norm">&nbsp;&nbsp;&nbsp;&nbsp; <input type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0156:     </tr>
0157:   </table>
0158: </form>
0159: </body>
0160: </html>