<%@LANGUAGE="VBSCRIPT"%> <% set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_Lydian_STRING Recordset1.Source = "SELECT NewsHeadline, NewsDate, NewsBody FROM News ORDER BY NewsDate DESC" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 3 Recordset1.Open() Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = 5 Dim Repeat1__index Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %>

About Us     Musicians     Repertoire     Listen     Media     News     Enquiry     Contact Us             <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %> <%=(Recordset1.Fields.Item("NewsHeadline").Value)%> <%=(Recordset1.Fields.Item("NewsDate").Value)%> <%=Replace((Recordset1.Fields.Item("NewsBody").Value), CHR(13), " ", 1)%>     About Us     Musicians     Repertoire     Listen     Media     News     Enquiry     Contact Us     Site hosted by ClearAuthor.

<% Recordset1.Close() %>