Count Lines in Pages
Contents of Page: SponsorEdit.asp
Number of Lines: 115
Last Modified: 8/22/2018 1:33:18 PM
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 
0006: 	SponsorID = Trim(Request.QueryString("SponsorID"))
0007: 
0008: 
0009: 	If SponsorID = "" Then
0010: 	   SponsorID = 0
0011: 	End If
0012: 
0013: 		action = "Edit"
0014: 		Set rs = Server.CreateObject("ADODB.Recordset")
0015: 		sqlString = "SELECT * FROM mmSponsors WHERE ID = " & SponsorID 
0016: 		'rs.Open sqlString, Conn, adOpenDynamic, adLockOptimistic, adCmdText
0017:  rs.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0018:   		If rs.EOF Then
0019: 
0020: 		ID = 0
0021: 
0022: 	 Else
0023:       Name = rs("Name").Value
0024:       Season = rs("Season").Value
0025:       SiteURL = rs("SiteURL").Value
0026:       ImageURL = rs("ImageURL").Value
0027:       SponsorAmount = rs("SponsorAmount").Value
0028:       Notes = rs("Notes").Value
0029: 
0030:      End If
0031: 
0032: 			rs.Close
0033: 		Set rs = Nothing
0034: 
0035: 
0036: %>
0037: <html>
0038: 
0039: <head>
0040: <title>Member Credit Maintenance</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.name.select()">
0048: 
0049: <form method="post" action="SponsorUpdate.asp?SponsorID=<% = SponsorID %>&ShowAll=<%= ShowAll %>" 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="900"
0053:   align="left">
0054: <tr><td>&nbsp;</td></tr>
0055: <tr><td>&nbsp; </td></tr>
0056: <tr><td>&nbsp; </td></tr>
0057: <tr><td>&nbsp; </td></tr>
0058:        <tr>
0059:       <td width="100" class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0060: 	  <b>Nome:</b></font></td>
0061:       <td class="norm" bgcolor="#f8f8f8" width="*">
0062: 	  <input type="text" name="Name" value="<%= Name %>" style="height: 22" size="100" class="norm"></td>
0063:     </tr>
0064:   <tr>
0065:     <tr>
0066:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0067: 	  <% If SiteURL <> "" Then %>
0068: 	   <a href="http://<%= SiteURL %>" target="_blank"><b>Site URL</b></a>:
0069: 	   <% Else %>
0070: 	  <b>Site URL:</b></font></td>
0071: 	  <% End If %>
0072:       <td class="norm" bgcolor="#f8f8f8">
0073: 	  <input type="text" name="SiteURL" value="<%= SiteURL %>" style="height: 22" size="100" class="norm">
0074: 	 
0075: 	  </td>
0076:     </tr>
0077:     <tr>
0078:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0079: 	  <% If SiteURL <> "" Then %>
0080: 	   <a href="http://<%= ImageURL %>" target="_blank"><b>Site URL</b></a>:
0081: 	   <% Else %>
0082: 	  <b>Image URL:</b></font></td>
0083: 	  <% End If %>
0084:       <td class="norm" bgcolor="#f8f8f8">
0085: 	  <input type="text" name="ImageURL" value="<%= ImageURL %>" style="height: 22" size="100" class="norm">
0086: 	 
0087: 	  </td>
0088:     </tr>
0089:   <tr>
0090:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0091: 	  <b>SponsorAmount:</b></font></td>
0092:       <td class="norm" bgcolor="#f8f8f8">
0093: 	  <input type="text" name="SponsorAmount" value="<%= SponsorAmount %>" style="height: 22" size="100" class="norm"></td>
0094:     </tr>
0095: 	    <tr>
0096:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0097: 	  <b>Season:</b></font></td>
0098:       <td class="norm" bgcolor="#f8f8f8">
0099: 	  <input type="text" name="Season" value="<%= Season %>" style="height: 22" size="50" class="norm"></td>
0100:     </tr>
0101: 	    <tr>
0102:       <td class="normbold" align="right"><font face="Arial" size="2" color="#008080">
0103: 	  <b>Notes:</b></font></td>
0104:       <td class="norm" bgcolor="#f8f8f8">
0105: 	  <input type="text" name="Notes" value="<%= Notes %>" style="height: 22" size="100" class="norm"></td>
0106:     </tr>
0107:     <tr>
0108:       <td ></td>
0109:       <td class="norm" align="left"><input type="submit" value="Update Sponsor"
0110:       class="norm"> <input type="button" value="Cancel" class="norm" onClick="history.back(-1)"></td>
0111:     </tr>
0112:   </table>
0113: </form>
0114: </body>
0115: </html>