<%@ Language="JScript" %> Jansen Construction, Inc. <% var SQL1 = "SELECT * FROM mpiJansen_innerPageTop"; SQL1 += " WHERE pageID = 6"; innerTop = conn.execute(SQL1); var SQL2 = "SELECT * FROM mpiJansen_miscBody"; SQL2 += " WHERE pageID = 6"; miscBody = conn.execute(SQL2); var old = 1985; var yearX = getYearX(theDate()); var yearNot = yearX - old; var SQLx = "SELECT * FROM mpiJansen_awardyear"; 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" && String(miscBody("pageContent")) != "") { %>

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

<% } if(!yearX.eof) {%> <% while(!yearX.eof) { var SQL3 = "SELECT DISTINCT yearX FROM mpiJansen_awards"; awards = conn.execute(SQL3); while(!awards.eof) { if(String(awards("yearX")) == String(yearX("yearX"))) {%> <% } awards.movenext; } %> <% var SQL3x = "SELECT * FROM mpiJansen_awards"; SQL3x += " ORDER BY yearX ASC"; awards1 = conn.execute(SQL3x); while(!awards1.eof) { if(String(awards1("yearX")) == String(yearX("yearX"))) {%> <% } awards1.movenext; } yearX.movenext; } var SQL4x = "SELECT * FROM mpiJansen_awards"; awards3 = conn.execute(SQL4x); if(!awards3.eof) { %><% }%>
<%=yearX("yearX")%>
<%=addBreaks(awards1("award"))%>

top
<% }%>
<% conn.close();%>