Job Postings search by keyword search by location <%Set oConn = Server.CreateObject("ADODB.Connection") DSNtest="DRIVER={SQL Server};SERVER=sql03.quilogy.net;UID=afni;PWD=!INSCRIBEDstone020603;DATABASE=16E941K121J5" oConn.open DSNtest Dim LocationSQL, LocationRS LocationSQL = "SELECT DISTINCT City, State FROM dbo.tblJobListings" Set LocationRS = oConn.Execute(LocationSQL) %> <% Do While NOT LocationRS.EOF%> <%=LocationRS(0)%> , <%=LocationRS(1)%> <% LocationRS.MoveNext Loop%> <%Set LocationRS = Nothing Set LocationSQL = Nothing%> search by department <%Dim DepartmentSQL, DepartmentRS DepartmentSQL = "SELECT ID AS Expr1, Department AS Expr2 FROM tblDepartments_VIEW" Set DepartmentRS = oConn.Execute(DepartmentSQL)%> <% Do While NOT DepartmentRS.EOF%> <%=DepartmentRS(1)%> <% DepartmentRS.MoveNext Loop%> <%Set DepartmentRS = Nothing Set DepartmentSQL = Nothing oConn.Close%>      Afni Careers Job Postings Benefits Employee Testimonials Upcoming Events EOE Statement   Copyright © 2003-2005 Afni, Inc. All Rights Reserved. Privacy Policy | This site is best viewed in 800 x 600