<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var news__MMColParam = "Y"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { news__MMColParam = String(Request("MM_EmptyValue")); } %> <% var news = Server.CreateObject("ADODB.Recordset"); news.ActiveConnection = MM_general_STRING; news.Source = "SELECT * FROM news WHERE Allowed = '"+ news__MMColParam.replace(/'/g, "''") + "' ORDER BY NewsID DESC"; news.CursorType = 0; news.CursorLocation = 2; news.LockType = 1; news.Open(); var news_numRows = 0; %> <% var forsale__MMColParam = "Y"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { forsale__MMColParam = String(Request("MM_EmptyValue")); } %> <% var forsale = Server.CreateObject("ADODB.Recordset"); forsale.ActiveConnection = MM_general_STRING; forsale.Source = "SELECT * FROM forsale WHERE Allowed = '"+ forsale__MMColParam.replace(/'/g, "''") + "'"; forsale.CursorType = 0; forsale.CursorLocation = 2; forsale.LockType = 1; forsale.Open(); var forsale_numRows = 0; %> <% var flatmates__MMColParam = "1"; if (String(Request.QueryString("Y")) != "undefined" && String(Request.QueryString("Y")) != "") { flatmates__MMColParam = String(Request.QueryString("Y")); } %> <% var flatmates = Server.CreateObject("ADODB.Recordset"); flatmates.ActiveConnection = MM_general_STRING; flatmates.Source = "SELECT * FROM flatmates WHERE Allowed = '"+ flatmates__MMColParam.replace(/'/g, "''") + "'"; flatmates.CursorType = 0; flatmates.CursorLocation = 2; flatmates.LockType = 1; flatmates.Open(); var flatmates_numRows = 0; %> <% var flats__MMColParam = "1"; if (String(Request.QueryString("Y")) != "undefined" && String(Request.QueryString("Y")) != "") { flats__MMColParam = String(Request.QueryString("Y")); } %> <% var flats = Server.CreateObject("ADODB.Recordset"); flats.ActiveConnection = MM_general_STRING; flats.Source = "SELECT * FROM flats WHERE Allowed = '"+ flats__MMColParam.replace(/'/g, "''") + "'"; flats.CursorType = 0; flats.CursorLocation = 2; flats.LockType = 1; flats.Open(); var flats_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; news_numRows += Repeat1__numRows; %> MARCHMONT WEB - Marchmont Community Website - Edinburgh, Scotland
<% while ((Repeat1__numRows-- != 0) && (!news.EOF)) { %>

<%=(news.Fields.Item("NewsHeading").Value)%>


<%=(news.Fields.Item("NewsDate").Value)%>


<%=(news.Fields.Item("NewsInfo").Value)%>


<%=(news.Fields.Item("NewsContact").Value)%>

<% Repeat1__index++; news.MoveNext(); } %>

New map launched


18 Feb 04


The new map is launched with all of the local shops & businesses included.



New website launched


14 Jan 04


The brand new Marchmont website has been launched. Come back soon to get all of the latest news & information on the local Edinburgh community.



HOME | BUSINESSES | NEWS | MAP | NOTICEBOARD | CONTACT

Site designed & maintained by: AACHEN PROJECT

<% news.Close(); %> <% forsale.Close(); %> <% flatmates.Close(); %> <% flats.Close(); %>