Count Lines in Pages
Contents of Page: DraftParticipantEdit.asp
Number of Lines: 93
Last Modified: 3/3/2023 12:47:54 PM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 
0006: 	ID = Request.QueryString(("ID"))
0007: GroupID = Request.Querystring("GroupID")
0008: 	
0009: Set rsd = Server.CreateObject("ADODB.Recordset")
0010: 	sqlString = "SELECT * FROM mmdraft " & _
0011: 			"WHERE ID = " & ID
0012: 	rsd.Open sqlString, conn, adOpenDynamic, adLockOptimistic, adCmdText
0013: 	If Not rsd.EOF Then
0014: 
0015: 			ID = rsd("ID").Value		
0016: 			RegNumber = rsd("RegNumber").Value
0017: 			DraftOrder = rsd("DraftOrder").Value
0018: 			LastName = rsd("LastName").Value
0019: 			FirstName = rsd("FirstName").Value
0020: 			
0021: 			If LastName = "" Then
0022: 
0023: 
0024: 			Set rsm = Server.CreateObject("ADODB.Recordset")
0025: 
0026:     		sqlString = "SELECT * FROM MY4_Master WHERE RegNumber = '" & RegNumber & "'"				
0027: 							
0028: 			rsm.Open sqlString, conn2, adOpenStatic, adLockReadOnly, adCmdText	
0029: 
0030: 			If Not rsm.EOF Then
0031: 
0032: 			LastName = rsm("LastName").Value
0033: 			FirstName = rsm	("FirstName").Value
0034: 
0035: 			rsm.Close
0036: 
0037: 			Else
0038: 
0039: 			LastName = "???"
0040: 			FirstName = "???"
0041: 
0042: 			End If
0043: 
0044: 			End If
0045: 		Else
0046: 		 
0047: 		 DraftOrder = 1
0048: 		
0049: 		End If
0050: 
0051: %>
0052: <html>
0053: 
0054: <head>
0055: <title>March Madness - Draft Participants Edit</title>
0056: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0057: <link href="mm.css" rel="stylesheet" type="text/css">
0058: 
0059: </head>
0060: 
0061: <body bgcolor="#FFFFFF" onLoad="document.node.RegNo.select()">
0062: 
0063: <form method="post" action="DraftParticipantEditPost.asp?ID=<%= ID %>" name="node">
0064:   <table border="0" cellpadding="1" cellspacing="1" width="400">
0065:   <input type="hidden" Name="GroupID" Value="<%= GroupID %>">
0066:   <input type="hidden" Name="DraftOrder" Value="<%= DraftOrder %>">
0067: 	  <tr>
0068:       <td class="normbold" width="60%"  align="right" ><font face="Arial" size="2" color="#008080"><b>RegNo</td>
0069:       <td   bgcolor="#f8f8f8" align="left" class="norm" ><input type="text" name="RegNumber" value="<%= RegNumber %>"></td>
0070:     </tr>
0071:     <tr>
0072:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>First Name</font></td>
0073:       <td class="norm" bgcolor="#f8f8f8" ><input type="text" name="FirstName"
0074:       value="<%= FirstName %>" style="width:200px" class="norm" size="20"></td>
0075:     </tr>
0076:     <tr>
0077:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Last Name</font></td>
0078:       <td class="norm" bgcolor="#f8f8f8" ><input type="text" name="LastName"
0079:       value="<%= LastName %>" style="width:200px" class="norm" size="20"></td>
0080:     </tr>
0081:     <tr>
0082:       <td  class="normbold" align="right"><font face="Arial" size="2" color="#008080"><b>Draft Order</font></td>
0083:       <td class="norm" bgcolor="#f8f8f8" ><%= DraftOrder %></td>
0084:     </tr>
0085:   
0086:     <tr><td></td>	
0087:       <td class="norm" align="left" colspan="4"><input type="submit" value="Update Participant" class="norm"> <input
0088:       type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0089:     </tr>
0090:   </table>
0091: </form>
0092: </body>
0093: </html>