Count Lines in Pages

Contents of Page: editSearchEntries.asp Number of Lines: 102 Last Modified: 8/22/2018 1:32:43 PM 
0001: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
0002: <!-- #include FILE="include/adovbs.inc" -->
0003: <!-- #include FILE="include/constants.inc" -->
0004: <%
0005: 	ID = Trim(Request.QueryString("ID"))
0006: 		action = "Update"
0007: 		Set rs = Server.CreateObject("ADODB.Recordset")
0008: 		sqlString = "SELECT * FROM mmEntries WHERE ID = " & ID
0009: 		rs.Open sqlString, Conn, adOpenDynamic, adLockOptimistic, adCmdText
0010: 		Name = rs("Name").Value
0011: 		FirstName = rs("FirstName").Value
0012:                 EmailAddress = rs("EmailAddress").Value
0013:                 Season = rs("Season").Value
0014:   
0015: 		InvalidEmail = rs("InvalidEmail").Value	
0016: 
0017: 		rs.Close	
0018: 
0019: %>
0020: <html>
0021: 
0022: <head>
0023: <title>Edit Search Result Entry</title>
0024: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
0025: <link href="admin.css" rel="stylesheet" type="text/css">
0026: <script language="JavaScript" type="text/javascript">
0027: 		function editNode(id)	{
0028: 			form = document.node;
0029: 			if (form.ID.value == "0")	{
0030: 				alert("A id value of 0 is not valid. Please change.");
0031: 				form.ID.select();
0032: 				return false;
0033: 			}
0034: 			// check for double quotes
0035: 			for (i=0; i<form.Name.value.length; i++)	{
0036: 				if (form.Name.value.charCodeAt(i) == 34)	{
0037: 					alert("Double quotes cannot be used in the name. Please change.");
0038: 					form.NodeName.select();
0039: 					return false;
0040: 				}
0041: 				// check for single quotes
0042: 				if (form.Name.value.charCodeAt(i) == 39)	{
0043: 					alert("Single quotes cannot be used in the name. Please change.");
0044: 					form.Name.select();
0045: 					return false;
0046: 				}
0047: 			}
0048: 			return true;
0049: 		}
0050: 	</script>
0051: </head>
0052: 
0053: <body bgcolor="#FFFFFF" onLoad="document.node.ID.select()">
0054: 
0055: <form method="post" action="mmSearchUpdate.asp?from=<% = from %>" name="node"
0056: onSubmit="return editNode()">
0057:   <input type="hidden" name="action" value="<%= action %>"><input type="hidden" name="ID"
0058:   value="<%= ID %>"><div align="center"><center><table border="0" cellpadding="1"
0059:   cellspacing="1" width="482">
0060:     <tr>
0061:       <td width="205" class="normbold" align="right"><div align="center"><center><p>ID</td>
0062:       <td width="269" class="norm" bgcolor="#f8f8f8" align="center"></td>
0063:     </tr>
0064:     <tr align="center">
0065:       <td width="205" class="normbold" align="right"><font face="Arial" size="2">Email Address</font></td>
0066:       <td class="norm" bgcolor="#f8f8f8" width="269"><div align="left"><p><input type="text"
0067:       name="EmailAddress" value="<%= EmailAddress %>" style="width:200px" class="norm" size="20"></td>
0068:     </tr>
0069:     <tr align="center">
0070:       <td width="205" class="normbold" align="right"><font face="Arial" size="2">Season</font></td>
0071:       <td class="norm" bgcolor="#f8f8f8" width="269"><div align="left"><p><input type="text"
0072:       name="Season" value="<%= Season %>" style="width:200px" class="norm" size="20"></td>
0073:     </tr>
0074:     <tr align="center">
0075:       <td width="205" class="normbold" align="right"><font face="Arial" size="2">First Name</font></td>
0076:       <td class="norm" bgcolor="#f8f8f8" width="269"><div align="left"><p><input type="text"
0077:       name="FirstName" value="<%= FirstName %>" style="width:200px" class="norm" size="20"></td>
0078:     </tr>
0079:     <tr align="center">
0080:       <td class="normbold" align="right" witdh="40%" width="205"><font face="Arial" size="2">Last
0081:       Name</font></td>
0082:       <td class="norm" bgcolor="#f8f8f8" width="269"><div align="left"><p><input type="text"
0083:       name="Name" value="<%= Name %>" style="width: 201; height: 23" class="norm" size="20"></td>
0084:     </tr>
0085:     <tr align="center">
0086:       <td class="normbold" align="right" witdh="40%" width="205"><font face="Arial" size="2">Bad
0087:       Email Address?</font></td>
0088:       <td class="norm" bgcolor="#f8f8f8" width="269"><div align="left"><p><input type="checkbox"
0089:       name="InvalidEmail" value="Y" <% If InvalidEmail = True Then %>checked<% End If %>
0090:       style="width:20; height:20" class="norm" size="20"> </td>
0091:     </tr>
0092:     <tr align="center">
0093:       <td witdh="40%" width="205"></td>
0094:       <td class="norm" align="center" width="269"><div align="left"><p><input type="submit"
0095:       value="<%= action %> Entry" class="norm"> <input type="button" value="Cancel" class="norm"
0096:       onClick="history.back(-1)"></td>
0097:     </tr>
0098:   </table>
0099:   </center></div>
0100: </form>
0101: </body>
0102: </html>