<%@ Language="JScript" %> Jansen Construction, Inc. <% var SQL1 = "SELECT * FROM mpiJansen_innerPageTop"; SQL1 += " WHERE pageID = 17"; innerTop = conn.execute(SQL1); var SQLx = "SELECT * FROM mpiJansen_experienceTitle"; SQLx += " WHERE recID=8"; titleX = conn.execute(SQLx); var SQList = "SELECT * FROM mpiJansen_experience"; SQList += " WHERE expID=8"; SQList += " ORDER BY titleX ASC"; list = conn.execute(SQList); %>
<%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(Request.QueryString("id")) != "undefined") { var SQLs = "SELECT im.recID, im.expID, im.imageName, exp.expID,"; SQLs += " exp.titleX, exp.recID, exp.description FROM"; SQLs += " mpiJansen_expImages as im, mpiJansen_experience as exp"; SQLs += " WHERE im.expID=exp.recID" SQLs += " AND exp.recID = '" + Request.QueryString("id") + "';"; experience = conn.execute(SQLs); if(!experience.eof) { var SQLx = "SELECT im.recID, im.expID,"; SQLx += " im.imageName, exp.recID, im.width, im.height FROM"; SQLx += " mpiJansen_expImages as im, mpiJansen_experience as exp"; SQLx += " WHERE im.expID=exp.recID" SQLx += " AND exp.recID = '" + Request.QueryString("id") + "';"; xImages = conn.execute(SQLx); %> <% if(!xImages.eof) { if(xImages(4) < 457) { var width = xImages(4); } else { var width = 457; } if(xImages(5) < 300) { var height = xImages(5); } else { var height = 300; } %>
<%=experience(4)%>

/projects/<%=xImages(2)%>" width="<%=width%>" height="<%=height%>" name="projectLarge" alt="" title="" class="imgBorder" hspace="2" />

<% var i=2; while(!xImages.eof) {%> <% var SQLcount ="SELECT COUNT(*) AS Expr1 FROM mpiJansen_expImages"; SQLcount += " WHERE expID="+ experience(5); recCount = conn.execute(SQLcount); if(recCount(0)>1) {%> (); onmouseover="displayItem<%=i%>();" onmouseout="" >/projects/<%=xImages(2)%>" width="41" height="41" name="project<%=i%>" alt="" title="" onmouseover="this.className='imgBorder2';" onmouseout="this.className='imgBorder'" class="imgBorder" hspace="2" /> <%} i++; xImages.movenext; } }%>
<%=addBreaks(experience(6))%>
<% } else { var SQLs2 = "SELECT * FROM mpiJansen_experience"; SQLs2 += " WHERE recID = '" + String(Request.QueryString("id")) + "';"; experience2 = conn.execute(SQLs2); %>

<%=experience2("titleX")%>

<%=addBreaks(experience2("description"))%>

<% } } else { var SQLb = "SELECT * FROM mpiJansen_miscBody"; SQLb += " WHERE pageID = 20"; miscBody = conn.execute(SQLb);%>

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

<% }%>

<%=titleX("expTitle")%>

    <% while(!list.eof) { if(String(list("description")) != "null" || String(list("imgFlag")) != "null") {%>
  • " class="cpLink"><%=list("titleX")%>
    • <% } else {%>
  • <%=list("titleX")%>
    • <% } list.movenext; }%>

<% conn.close();%>