|
| Latest News |
<%
MM_HomeOffice_STRING = "DSN=Home_Office;"
'----- Read the news
set oDBCon = Server.CreateObject("ADODB.Connection")
oDBCon.ConnectionString = MM_HomeOffice_STRING
oDBCon.open
set oRSNews = Server.CreateObject("ADODB.Recordset")
oRSNews.ActiveConnection = oDBCon
oRSNews.Source = _
"SELECT TOP 8 * FROM BB_Bulletin " & _
"WHERE (Type_ID = 1) AND (Status = 'A') AND (Extra like '%Theme=NewCouncil%') AND (CONVERT(DATETIME, Date_From, 102) <= CONVERT(DATETIME, '" & day(now) & " " & monthname(month(now)) & " " & year(now) & "', 102)) " & _
"ORDER BY Sort_Ranking ASC, Date_From DESC"
oRSNews.CursorType = 0: oRSNews.CursorLocation = 2: oRSNews.LockType = 3
oRSNews.Open()
%>
|
| KEY Documents |
|
|
| KEY INFORMATION |
|
|
Northumberland Election 2008 Video
Electing Head Students
Who will be the new Head Boy and Head Girl of King Edward VI School in September 2008?
Watch the candidates canvass for votes as they try and encourage Year 11 to vote for them.