<%@Language=vbscript%> <% On Error Resume Next Response.Buffer=True Response.Expires = -1000 'Make Connection for Page Data Dim cn Dim rs Dim sql 'Open Database Connection Set cn = Server.CreateObject("adodb.connection") cn.ConnectionString = strconn cn.Open 'Setup Query sql = "Select * From CareersHomePage" 'Should Only Be One Record 'Open Recordset and Get page Data Set rs = Server.CreateObject("adodb.recordset") rs.ActiveConnection = cn rs.Open sql 'Check for Errors...Display an Error Message If (err.number <> 0) then 'Simple Error handling Response.Write err.Description End IF %> Marsh Furniture Company - Careers

 

<%'Start Dynamic Page population from SQL Server Do until rs.EOF %>
 

" width="515" height="246">

<%= rs("CareersHomeText")%>

<%= rs("CareersHomeText2")%>

" class="underline"><%= rs("CareersHomeLink1Text")%>

" class="underline"><%= rs("CareersHomeLink2Text")%>

" class="underline"><%= rs("CareersHomeLink3Text")%>

" width="88" height="31" onclick="javascript: window.open('<%= rs("CareersHomeAcrobatLink")%>');">

Email Marsh Human Resources at resumes@marshfurniture.com.

<%rs.MoveNext Loop 'Close Connection rs.Close cn.Close %>