<% Dim id_metier Dim id_region id_metier = Request.QueryString("metier") id_region = Request.QueryString("region") 'definition de variable sql="SELECT REGION, count(REGION) AS RESULT_REGION FROM Offre_emploi GROUP BY REGION" rs.open sql,conn,1,1 set rs1= Server.CreateObject("ADODB.Recordset") sql1="SELECT CATEGORIE, count(CATEGORIE) AS RESULT_CATEGORIE FROM Offre_emploi GROUP BY CATEGORIE" rs1.open sql1,conn,1,1 set rs2= Server.CreateObject("ADODB.Recordset") sql2 ="SELECT * FROM Offre_emploi ORDER BY DATE_DEBUT DESC" rs2.open sql2,conn,1,1 %> Recrutement - Sécurité, Hygiène & accessibilité - Expertiss " />

Recrutement

Consulter nos offres d'emplois par métiers ou par régions :



<% set rs4= Server.CreateObject("ADODB.Recordset") if (id_region<>"") then response.write(id_region) sql4 ="SELECT * FROM Offre_emploi WHERE REGION='"+id_region+"' ORDER BY DATE_DEBUT DESC" SELvar = id_region Elseif (id_metier<>"") then Selvar1 = Replace(id_metier, "'", "''") sql4 ="SELECT * FROM Offre_emploi WHERE CATEGORIE='"+Selvar1+"' ORDER BY DATE_DEBUT DESC" SELvar = id_metier Else sql4 ="SELECT * FROM Offre_emploi ORDER BY DATE_DEBUT DESC" SELvar = "Toutes les offres" End If rs4.open sql4,conn,1,1 %>

EXPERTISS vous propose <%=(rs4.Recordcount)%> offres d'emploi pour le critère de recherche "<%=SELvar%>".

<% i=0 While (NOT rs4.EOF) i = i+1 if (i mod 2)=0 then rsMODULO = "tabnormal" else rsMODULO = "tabalternate" end if %> '"onmouseover="this.className='tabhover'" onmouseout="this.className='<%=rsMODULO%>'"> <% rs4.MoveNext() Wend %>
Date Secteur Description du poste Ville
<%=rs4.Fields("DATE_DEBUT")%> <%=rs4.Fields("INTITULE")%> <%=(left(rs4.Fields("MISSION").Value,40) & "...")%> <%=rs4.Fields("VILLE")%>