Count Lines in Pages
Contents of Page: PropResultsUpdate.asp
Number of Lines: 60
Last Modified: 8/22/2018 1:33:12 PM
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: 	PropBetID = Trim(Request.QueryString("PropBetID"))
0008: 	Show = Trim(Request.QueryString("Show"))
0009: 
0010: 
0011: 		Set rs = Server.CreateObject("ADODB.Recordset")
0012: 		sqlString = "SELECT * FROM PropBets WHERE ID = " & PropBetID 
0013: 	   rs.Open sqlString, Conn3, adOpenDynamic, adLockOptimistic, adCmdText
0014: 
0015:   	If rs.EOF Then
0016:  		    rs.AddNew
0017:     End If 
0018: 
0019:    
0020: 	EventID = Request.Form("EventID")
0021: 
0022: 
0023: 	  PropDescription = Request.Form("PropDescription")
0024:       Option1 = Trim(Request.Form("Option1"))
0025:       Option2 = Trim(Request.Form("Option2"))
0026:       Option3 = Trim(Request.Form("Option3"))
0027:       Option4 = Trim(Request.Form("Option4"))
0028:       Option5 = Trim(Request.Form("Option5"))
0029:       WhoWon = Request.Form("WhoWon")
0030:       ActualResult = Request.Form("ActualResult")
0031:       DisplayOrder = Request.Form("DisplayOrder")
0032: 
0033: 	   rs("Season").Value = Season 
0034: 	  rs("PropDescription").Value = PropDescription 
0035:       rs("Option1").Value = Option1 
0036:       rs("Option2").Value = Option2
0037:       rs("Option3").Value = Option3 
0038:       rs("Option4").Value = Option4
0039:       rs("Option5").Value = Option5
0040: 	  rs("WhoWon").Value =  WhoWon
0041: 	  rs("ActualResult").Value =  ActualResult
0042:       rs("DisplayOrder").Value = DisplayOrder
0043: 		rs.Update
0044: 		rs.Close
0045: 		Set rs = Nothing
0046: 
0047: 
0048: 	Response.Redirect("PropResultsMaint.asp?EventID=" & EventID & "&Show=" & Show)
0049: '	Response.Write("CreditDetails.asp?CurrYear=" & FEYear & "&MemberID=" & MemberID & "&ShowAll =" & ShowAll)
0050: 
0051: %>
0052: <html>
0053: 
0054: <head>
0055: <title></title>
0056: </head>
0057: 
0058: <body>
0059: </body>
0060: </html>