<%@ Language="JScript" %> Jansen Construction, Inc. <% var SQL1 = "SELECT * FROM mpiJansen_innerPageTop"; SQL1 += " WHERE pageID = 1"; innerTop = conn.execute(SQL1); var SQList = "SELECT * FROM mpiJansen_CurrentProjects"; SQList += " ORDER BY editDate DESC, title 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.imageName, cp.imageID,"; SQLs += " cp.title, cp.recID, cp.description FROM"; SQLs += " mpiJansen_images as im, mpiJansen_CurrentProjects as cp"; SQLs += " WHERE im.recID=cp.imageID" SQLs += " AND cp.recID = '" + Request.QueryString("id") + "';"; projects = conn.execute(SQLs); if(!projects.eof) { var SQLx = "SELECT im.recID, im.projID,"; SQLx += " im.imageName, cp.recID FROM"; SQLx += " mpiJansen_CPX_images as im, mpiJansen_CurrentProjects as cp"; SQLx += " WHERE im.projID=cp.recID" SQLx += " AND cp.recID = '" + Request.QueryString("id") + "';"; xImages = conn.execute(SQLx); %>
<%=projects(3)%>

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

<% if(!xImages.eof) {%> /projects/<%=projects(1)%>" width="41" height="41" name="project1" alt="" title="" onmouseover="this.className='imgBorder2';" onmouseout="this.className='imgBorder'" class="imgBorder" hspace="2" /> <% var i=2; while(!xImages.eof) {%> (); 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; } }%>
<%if(String(addBreaks(projects(5))) != "null" ) { %><%=addBreaks(projects(5))%><%}%>
<% } else { var SQLs2 = "SELECT * FROM mpiJansen_CurrentProjects"; SQLs2 += " WHERE recID = '" + String(Request.QueryString("id")) + "';"; projects2 = conn.execute(SQLs2); %>

<%=projects2("title")%>

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

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

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

<% }%>

Project List

<% conn.close();%>