<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Dim RS_News Dim RS_News_cmd Dim RS_News_numRows Set RS_News_cmd = Server.CreateObject ("ADODB.Command") RS_News_cmd.ActiveConnection = MM_two_mills_STRING RS_News_cmd.CommandText = "SELECT * FROM News ORDER BY newsID DESC" RS_News_cmd.Prepared = true Set RS_News = RS_News_cmd.Execute RS_News_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 RS_News_numRows = RS_News_numRows + Repeat1__numRows %> Two Mills - News

News

<% While ((Repeat1__numRows <> 0) AND (NOT RS_News.EOF)) %>
<%=(RS_News.Fields.Item("postDate").Value)%>
<%=(RS_News.Fields.Item("headline").Value)%>
.jpg" width="314" height="229" />
<%=(RS_News.Fields.Item("description").Value)%>
<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 RS_News.MoveNext() Wend %>

 

 

<% RS_News.Close() Set RS_News = Nothing %>