<%@LANGUAGE="JAVASCRIPT" LCID=2057%>
<% var intLastNewsItem = 0; %>
<%
var News_cmd = Server.CreateObject ("ADODB.Command");
News_cmd.ActiveConnection = MM_connRemoteControlRecords_STRING;
News_cmd.CommandText = "SELECT NewsID, NewsDate, Headline, DateExpires FROM remjimbr.tblNews WHERE (DotDash = 1 AND NOT(DateExpires < getdate())) ORDER BY NewsDate DESC";
News_cmd.Prepared = true;
var News = News_cmd.Execute();
var News_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
News_numRows += Repeat1__numRows;
%>
dot dash - News Archive
<%
var AdvertRS_cmd = Server.CreateObject ("ADODB.Command");
AdvertRS_cmd.ActiveConnection = MM_connRemoteControlRecords_STRING;
AdvertRS_cmd.CommandText = "SELECT * FROM tblFlashAd WHERE Active = 1";
AdvertRS_cmd.Prepared = true;
var AdvertRS = AdvertRS_cmd.Execute();
var AdvertRS_numRows = 0;
// Select a random row number
AdvertRS.MoveFirst();
var i = 1;
while (!AdvertRS.EOF) {
AdvertRS.MoveNext();
i++
}
var rndMax = i;
var rndNumber;
rndNumber = Math.floor(rndMax * Math.random());
rndNumber = rndNumber + 1; //Add one to prevent it from going to zero, and to make it count the last record too
if (rndMax > 0) {
AdvertRS.MoveFirst();
var i = 1;
while (i < rndNumber) {
AdvertRS.MoveNext();
i++
}
}
%>
