<%@ Language="JScript" %> Jansen Construction, Inc. <% var SQL1 = "SELECT * FROM mpiJansen_innerPageTop"; SQL1 += " WHERE pageID = 9"; innerTop = conn.execute(SQL1); var SQL2 = "SELECT * FROM mpiJansen_miscBody"; SQL2 += " WHERE pageID = 9"; miscBody = conn.execute(SQL2); var old = 2000; var yearX = getYearX(theDate()); var yearNot = yearX - old; var SQLx = "SELECT * FROM mpiJansen_pressReleaseYear"; SQLx += " Where yearX <="+yearX; SQLx += " ORDER by yearX DESC"; yearX = conn.execute(SQLx); %>
<%if(String(innerTop("title1")) != "null" && String(innerTop("title1")) != "") {%>

<%=innerTop("title1")%>

<%} if(String(innerTop("title2")) != "null" && String(innerTop("title2")) != "") {%>

<%=innerTop("title2")%>

<%} if(String(innerTop("pageContent")) != "null" && String(innerTop("pageContent")) != "") { %>

<%=addBreaks(innerTop("pageContent"))%>

<% }%>
<% if(String(miscBody("pageContent")) != "null" ) { %>

<%=addBreaks(miscBody("pageContent"))%>

<% } if(!yearX.eof) {%> <% while(!yearX.eof) { var SQL3 = "SELECT DISTINCT yearX FROM mpiJansen_pressRelease"; pr = conn.execute(SQL3); while(!pr.eof) { if(String(pr("yearX")) == String(yearX("yearX"))) {%> <% } pr.movenext; } %> <% var SQL3x = "SELECT * FROM mpiJansen_pressRelease"; SQL3x += " ORDER BY yearX ASC"; pr1 = conn.execute(SQL3x); while(!pr1.eof) { if(String(pr1("yearX")) == String(yearX("yearX"))) {%> <% } pr1.movenext; } yearX.movenext; } var SQLcount ="SELECT COUNT(*) AS Expr1 FROM mpiJansen_pressRelease"; recCount = conn.execute(SQLcount); if(recCount(0) > 5) { %><% }%>
<%=yearX("yearX")%>
<%=pr1("titleX")%>

<%=addBreaks(pr1("pressRelease"))%>
top
<% }%>
<% conn.close();%>