Count Lines in Pages
Contents of Page: mminvitationemail.asp
Number of Lines: 73
Last Modified: 2/27/2023 2:31:50 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: 
0008:   CRLF = chr(13) & chr(10)
0009: 
0010:     
0011: 	Set rsPYPicks = Server.CreateObject("ADODB.Recordset")
0012: 	sqlString = "SELECT SUM(NumEntries) AS TotalEntries FROM mmEntries " & _
0013: 							"WHERE Season = " & season & " " 
0014: 	rsPYPicks.Open sqlString, conn, adOpenStatic, adLockReadOnly, adCmdText
0015: 	
0016: 	
0017: 
0018: 	PYCount = rsPYPicks("TotalEntries").Value
0019:     rsPYPicks.Close
0020: 
0021: 	years = season - 1989
0022: 
0023: sufix = "th"
0024: LastD = Right(years,1)
0025: If LastD = "1" Then
0026: sufix = "st"
0027: End If
0028: If LastD = "2" Then
0029: sufix = "nd"
0030: End If
0031: If LastD = "3" Then
0032: sufix = "rd"
0033: End If
0034: 
0035:    %>
0036: <html>
0037: 
0038: <head>
0039: <title>March Madness Contest - Invitation </title>
0040: </head>
0041: 
0042: <body>
0043: 
0044: <table width="100%"  border="2" cellspacing="2" cellpadding="7">
0045: <tr><td class="norm">   
0046: 
0047:  <%
0048: 
0049:  Message = "Hi there everyone, " & CRLF & CRLF
0050: 
0051: Message = Message & "It's that time of the year again!   Registration is now open for the " & Years & sufix & " annual edition of this contest." & CRLF & CRLF
0052: 
0053: Message = Message & "You can register now and be ready to make your picks when the field for the " & season & " NCAA Men's Basketball Tournament is announced on " & SelSunday & "." & CRLF & CRLF
0054: 
0055: Message = Message & "Just go to https://www.folga.org/mm or https://www.folga.org/mm/mobile." & CRLF & CRLF
0056: 
0057: Message = Message & "All proceeds are donated to the City of Hope Cancer Research Institute." & CRLF & CRLF
0058: 
0059: Message = Message & "Thanks in advance for your participation." & CRLF & CRLF
0060: 
0061: Message = Message & "Sincerely," & CRLF & CRLF
0062: 
0063: Message = Message & "Joe Toledo" & CRLF & CRLF
0064: 
0065: 
0066: %>
0067: <tr><td><input size="100" value="March Madness Contest to benefit Cancer Research - Registration now open / Update# NN - <%= PYCount %> Entries so far..."></input></td></tr>
0068: <tr><td class="norm">
0069: <textarea rows="30" name="message" cols="150"><%= Message %></textarea></td></tr>
0070: <tr><td class="norm"><input type="button" value="Return" class="norm" onClick="history.back(-1)"></td>
0071: </table>
0072: </body>
0073: </html>