|
Join the 2006 Raider Club!
Become an important part of the on going tradition of strong support for the LCSD Go there now. |
|
|
|
<%
Dim httphost
httphost = Lcase(Request.ServerVariables("HTTP_HOST"))
'strip host name of prefixes, down to domain only
If InStr( (InStr(httphost, ".") + 1), httphost, ".") > 0 Then
'prefix found
httphost = Mid( httphost, (InStr(httphost, ".") + 1), Len(httphost))
End If
Dim connection, cmd, rs, UIString
Set cmd = Server.CreateObject("ADODB.Command")
Set connection = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
'Open Connection
connection.ConnectionString = Application("NativeSQL_ConnectionString")
connection.Open
cmd.ActiveConnection = connection
cmd.CommandText = "SP_ANNOUNCEMENT_GET_DSCOMP"
cmd.CommandType = 4
cmd.Parameters(1).Value = httphost
rs.Open cmd, ,adOpenStatic
UIString = ""
'build html
If rs.EOF Then
UIString = "No announcements for " + FormatDateTime(Now(), 1)
Else
Do Until rs.EOF
UIString = UIString & " " & rs.Fields(0).Value & ""
rs.MoveNext
Loop
End If
rs.Close
connection.Close
Set connection = Nothing
Set cmd.ActiveConnection = Nothing
Set cmd = Nothing
Set rs = Nothing
Response.Write UIString + ""
%>
|
|
|
The Official web site of the London High School Athletic Program.
Partner with Madison County's most visited web site, and number one resource for
London High School
and Middle School Sports to reach your target audience.
A word from Terry Nance, LHS Athletic Director
LondonRedRaiders.com has become the primary resource for London High School and Middle School Athletics. It really is the best thing I've ever done to promote the Athletic Program and it's Student Athletes. It's success would not have been possible, nor would we have received such a tremendous response from our community, without the support of our gracious Advertisers! Your Business is receiving great exposure everyday, and we hope that you will visit RedRaiders.com on a regular basis to stay up to date with our Program, Student Athletes, and Community.
WELCOME
ABOARD!
Terry Nance,
LHS Athletic Director
|
|