<% insert_menu(0); %>
<% title_block("news archives", "home | search"); %>
|
|
<%
conn = Server.CreateObject("ADODB.Connection");
conn.Open("DSN=admain");
rs = Server.CreateObject("ADODB.RecordSet");
sql = "select photo, date_format(pubdate, '%e %b %y') as pbdate, title, abstract, link from news";
sql = sql + " where year(pubdate) = '" + news_year + "' and month(pubdate) = '" + news_month + "'";
sql = sql + " order by pubdate asc, id asc";
rs.Open(sql, conn);
if (rs.EOF)
{
rs.Close();
conn.Close();
Response.write("Sorry, there were no news items found for the selected month. ");
}
else
{
Response.write(" | | Note: Some of the links to news items\n");
Response.write("may no longer work - it is entirely dependent on how long each news source keeps\n");
Response.write("it's older stories online. | \n");
Response.write("");
while (!(rs.EOF))
{
Response.write("\n");
Response.write("![](images/news/" + String(rs.fields.item("photo")) + ") | \n");
Response.write("" + String(rs.fields.item("title")) + "
\n");
Response.write("" + String(rs.fields.item("pbdate")) + " - ");
Response.write(String(rs.fields.item("abstract")) + " more... | \n");
Response.write(" \n");
rs.move(1);
}
rs.Close();
conn.Close();
Response.write(" ");
}
%>
|
|
|
<% insert_footer(); %>
|
|