<%
Careers = "-over"
id = request.querystring("id")
if len(id) > 0 then
sqltext = "SELECT Career_Category.CategoryName FROM Career_Category WHERE id = " & id
rs.open sqltext,conn,2,2
If not rs.bof then
Category = rs("CategoryName")
PageContent = PageContent & "" & Category & "
" & vbCrLf
end if
rs.close
sqltext = "SELECT * FROM Careers WHERE Category = " & id
rs.open sqltext,conn,2,2
If not rs.bof then
Do While not rs.eof
Title = rs("Title")
Description = rs("Description")
CareerDate = rs("CareerDate")
PageContent = PageContent & "" & Title & "
" & vbCrLf
PageContent = PageContent & CareerDate & "
" & vbCrLf
PageContent = PageContent & Description & "
" & vbCrLf
rs.MoveNext
Loop
end if
rs.close
else
' PageContent = "
"
sqltext = "SELECT DISTINCT Career_Category.* FROM Career_Category INNER JOIN Careers ON Careers.Category = Career_Category.id ORDER BY Career_Category.CategoryName;"
rs.open sqltext,conn,2,2
If not rs.bof then
Do While not rs.eof
Categoryid = rs("id")
Category = rs("CategoryName")
PageContent = PageContent & "" & Category & "
" & vbCrLf
rs.MoveNext
Loop
else
PageContent = "Sorry, we currently have no positions available. Please check back though because we update this page often."
end if
rs.close
end if
%>
Post Resume
Brown Evans Distributing has approximately 60 employees serving the state of Arizona. We offer a challenging and exciting workplace that encompasses a variety of fields. Opportunities for growth and advancement provide an environment where employees feel like part of team and can be happy in a long-term career.
<%= PageContent %>
