Latest News
<%
Dim Connection
Dim RecordSet
Dim Date
Dim Count
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Web\fpdb\newswire.mdb;"
strSQL = "SELECT TOP 3 * FROM releases WHERE txtTopic='Arts & Sciences' OR txtTopic='ABR' ORDER BY id DESC"
Set RecordSet = Server.CreateObject("ADODB.RecordSet")
RecordSet.Open strSQL,Connection
Date = Now()
Count = 0
Do While not (RecordSet.EOF OR RecordSet.BOF)
Count = Count + 1
%>
"><%=RecordSet.Fields("Title")%>
<%=RecordSet.Fields("txtMonth")%>/<%=RecordSet.Fields("txtDay")%>/<%=RecordSet.Fields("txtYear")%>
<%
RecordSet.MoveNext
Loop
RecordSet.Close
If Count <= 0 Then
%>
Section unavailable.
<%
End If
Connection.Close
Set Connection = Nothing
Set Access = Nothing
Set RecordSet = Nothing
%>