Count Lines in Pages
Contents of Page: PropEventEdit.asp
Number of Lines: 94
Last Modified: 8/22/2018 1:33:10 PM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 
0006: 	PropEventID = Trim(Request.QueryString("PropEventID"))
0007: 	If PropEventId = "" Then
0008: 	PropEventID = 0
0009: 	End If
0010: 
0011: 		Set rs = Server.CreateObject("ADODB.Recordset")
0012: 		sqlString = "SELECT * FROM PropEvents WHERE ID = " & PropEventID 
0013: 		'rs.Open sqlString, Conn, adOpenDynamic, adLockOptimistic, adCmdText
0014:  rs.Open sqlString, conn3, adOpenStatic, adLockReadOnly, adCmdText
0015:   		If rs.EOF Then
0016:  EventID = 0
0017: 	 Else
0018:       EventID = CInt(rs("ID").Value)
0019: 	  EventDescription = rs("EventDescription").Value
0020: 
0021:       FirstName = rs("FirstName").Value
0022:       SecondName = rs("SecondName").Value
0023: 	  StopMakingPicks = rs("StopMakingPicks").Value
0024:      End If
0025: 
0026: 			rs.Close
0027: 		Set rs = Nothing
0028: 
0029: 
0030: %>
0031: <html>
0032: 
0033: <head>
0034: <title>PickASquare - Prop Event Update</title>
0035: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0036: <link href="admin.css" rel="stylesheet" type="text/css">
0037: 
0038: 
0039: </head>
0040: 
0041: <body bgcolor="#FFFFFF" onLoad="document.node.EventDescription.select()">
0042: 
0043: <form method="post" action="PropEventsUpdate.asp?PropEventID=<%= PropEventID %>&Show=<%= Show %>" name="node"
0044: onSubmit="return checkEntry()">
0045:   <input type="hidden" name="action" value="<%= action %>"><input type="hidden" name="ID"
0046:   value="<%= ID %>">
0047:   <table border="0" cellpadding="1" cellspacing="1" width="500"  align="left">
0048:     <tr>
0049:       <td width="35%" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0050: 	  <b>PropEventID:</b></font></td>
0051:       <td class="norm" bgcolor="#f8f8f8" align="left"><%= PropEventID %></td>
0052:     </tr>
0053:        <tr>
0054:       <td width="35%" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0055: 	  <b>Event Description:</b></font></td>
0056:       <td class="norm" bgcolor="#f8f8f8"  >
0057: 	  <input type="text" name="EventDescription" value="<%= EventDescription %>" style="height: 22" size="50" class="norm"></td>
0058:     </tr>
0059:   <tr>
0060: 
0061: 	    <tr>
0062:       <td width="35%" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0063: 	  <b>First Name:</b></font></td>
0064:       <td class="norm" bgcolor="#f8f8f8"  >
0065: 	  <input type="text" name="FirstName" value="<%= FirstName %>" style="height: 22" size="25" class="norm"></td>
0066:     </tr>
0067: 	    <tr>
0068:       <td width="35%" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0069: 	  <b>Second Name:</b></font></td>
0070:       <td class="norm" bgcolor="#f8f8f8"  >
0071: 	  <input type="text" name="SecondName" value="<%= SecondName %>" style="height: 22" size="25" class="norm"></td>
0072:     </tr>
0073: 	    <tr>
0074:       <td width="35%" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0075: 	  <b>Stop Making Picks:</b></font></td>
0076:       <td class="norm" bgcolor="#f8f8f8"  >
0077: 	  <select name="StopMakingPicks" size="1">
0078:         <option selected value="<%= StopMakingPicks %>"><%= StopMakingPicks %></option>
0079:         <option value="YES">YES</option>
0080:         <option value="NO">NO</option>
0081:       </select>
0082: </td>
0083:     </tr>
0084: 
0085:   
0086:     <tr>
0087:       <td width="35%"></td>
0088:       <td class="norm" align="left"  ><input type="submit" value="Update Result"
0089:       class="norm"> <input type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0090:     </tr>
0091:   </table>
0092: </form>
0093: </body>
0094: </html>