Voici le code:
<table width="720" height="677" border="0" cellpadding="0" cellspacing="0" background="">
<!--DWLayoutTable-->
<tr>
<td colspan="4"><div align="right"><img src="../tronc%20commun/images/Auvergne%20presentation.gif" width="100" height="124" border="0" usemap="#Map">
<map name="Map">
<area shape="poly" coords="23,75,18,80,12,86,10,93,10,101,11,110,14,109,18,109,28,96,34,98,37,104,40,97,46,94,45,89,38,80" href="../cantal/index.htm" alt="Département du Cantal">
<area shape="poly" coords="45,79,53,77,64,79,74,79,80,78,85,84,81,91,75,97,69,103,62,99,55,100,51,91" href="../hte%20loire/index.htm" alt="Département de la Haute-Loire">
<area shape="poly" coords="26,41,25,49,21,54,23,62,24,68,31,73,38,76,46,73,53,71,57,74,65,73,68,67,60,58,58,48,45,43,33,37" href="../puy%20de%20dome/index.htm" alt="Département du Puy de Dôme">
<area shape="poly" coords="32,10,28,14,25,19,18,22,18,27,24,36,32,32,39,37,44,39,52,41,59,44,62,41,62,33,68,27,68,23,60,20,58,13,45,12" href="../allier/index.htm" alt="Département de l'Allier">
</map>
</div>
<div align="center"><font size="2" face="Arial, Helvetica, sans-serif"></font></div></td>
</tr>
<tr>
<td width="91" height="19"> </td>
<td width="45"> </td>
<td width="577" bgcolor="#004777"> <div align="center"><font color="#FFFFFF" size="3" face="Arial, Helvetica, sans-serif"><strong>OFFRES
D'EMPLOI</strong></font></div></td>
<td width="7"> </td>
</tr>
<tr>
<td height="19" valign="top" background="../hte%20loire/images/fond%20boutonbis.gif"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> Présentation</strong></font></td>
<td> </td>
<td colspan="2" rowspan="17" align="right" valign="top" background="../tronc%20commun/images/fond%20tab2.gif">
<table width="580" height="40" border="0" align="center" cellspacing="0" background="../tronc%20commun/images/p_resultemploi.gif">
<tr>
<td width="575" height="35"> <%'-- affichage par défaut du choix selectionné--!%> <form name="form1" method="post" action="recherche_off.asp">
<div align="left"><strong><font size="2" face="Arial, Helvetica, sans-serif">Départements
</font></strong>
<select name="off_dep">
<option value="0">Choisir un département</option>
<option value="3"<%if dep="3" then
response.write "Selected"
end if%>>Allier</option>
<option value="15"<%if dep="15" then
response.write "Selected"
end if%>>Cantal</option>
<option value="43"<%if dep="43" then
response.write "Selected"
end if%>>Haute-Loire</option>
<option value="63"<%if dep="63" then
response.write "Selected"
end if%>>Puy de Dôme</option>
</select>
<strong><font size="2" face="Arial, Helvetica, sans-serif">Filières</font></strong>
<select name="off_fil">
<option value="0">choisir une filière</option>
<option value="1"<%if fil="1" then
response.write "Selected"
end if%>>Administrative</option>
<option value="2"<%if fil="2" then
response.write "Selected"
end if%>>Technique</option>
<option value="3"<%if fil="3" then
response.write "Selected"
end if%>>Culturelle</option>
<option value="4"<%if fil="4" then
response.write "Selected"
end if%>>Sportive</option>
<option value="5"<%if fil="5" then
response.write "Selected"
end if%>>Sanitaire et social</option>
<option value="6"<%if fil="6" then
response.write "Selected"
end if%>>Sapeur pompier prof.</option>
<option value="7"<%if fil="7" then
response.write "Selected"
end if%>>Sécurité</option>
<option value="8"<%if fil="8" then
response.write "Selected"
end if%>>Animation</option>
</select>
<input name="imageField" type="image" src="../tronc%20commun/images/louperech.gif" width="40" height="20" border="0">
</div>
</form></td>
</tr>
</table>
<div align="center"><br>
<%'-- lecture du fichier offre , si pas de choix de département et/ou de filière--!%>
<%if request("off_dep" ) = 0 and request("off_fil" )= 0 then
sql="select * from offre order by offre_departement "
Set rs = Server.CreateObject("ADODB.RecordSet" )
rs.open SQL,connexion,3
else
if request("off_dep" ) = 0 then
sql="select * from offre where offre_fil="&request("off_fil" )
Set rs = Server.CreateObject("ADODB.RecordSet" )
rs.open SQL,connexion,3
else
if request("off_fil" ) = 0 then
sql="select * from offre where offre_departement="&request("off_dep" )
Set rs = Server.CreateObject("ADODB.RecordSet" )
rs.open SQL,connexion,3
end if
end if
end if %>
<%if rs.eof then %>
<font size="2" face="Arial, Helvetica, sans-serif"> <strong>Désolé
, il n'y a pas d'annonce</strong></font>
<%else %>
</div>
<table width="580" border="0" cellspacing="0">
<tr>
<%'-- lecture du fichier offre , avec lien sur loupe et libelle pour détailler l'offre--!%>
<% Do While Not rs.EOF %>
<td width="526" bgcolor="#628EAB"> <a href="detail_offre.asp?idoffre=<%=rs("offre_code" )%>"
onclick="window.open('','popup','width=600,height=500,scrollbars=1'
"
Target="popup" class="lienemploi"> <font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">
<strong><%=rs("offre_libelle" )%></strong></font> </a> </td>
<td width="60"> <a href="detail_offre.asp?idoffre=<%=rs("offre_code" )%>"
onclick="window.open('','popup','width=600,height=500,scrollbars=1'"
Target="popup"> <img src="../tronc%20commun/images/loupe.gif" width="47" height="20" border= "0"></a>
<%'-- lecture de la table filière, --!%> </td>
<%sql2="select * from filiere where fil_code=" & rs("offre_fil" )
Set rs2 = Server.CreateObject("ADODB.RecordSet" )
rs2.open SQL2,connexion,3%>
</tr>
<td> <font size="1" face="Arial, Helvetica, sans-serif"><strong>Filière
:</strong> <%Response.Write rs2("fil_libelle" )%> </td>
<td></td>
</tr>
<tr>
<%'-- lecture de la table offregrade, pour afficher tous les grades demandés dans l'offre --!%>
<%sql3="select * from offregrade where og_code="& rs("offre_code" )
Set rs3 = Server.CreateObject("ADODB.RecordSet" )
rs3.open SQL3,connexion,3
i = 1
Do While Not rs3.EOF
sql4="select * from grade where grade_code="& rs3("og_clegrade" )
Set rs4 = Server.CreateObject("ADODB.RecordSet" )
rs4.open SQL4,connexion,3
if i = 1 then%>
<td> <font size="1" face="Arial, Helvetica, sans-serif"><strong>cadre(s)
d'emploi :</strong> <%'-- grade cliquable pour afficher le détail de la fonction --!%> <a href="detail_fonction.asp?idgrade=<%=rs4("grade_code" )%>"
onclick="window.open('','popup','width=600,height=500,scrollbars=1'"
Target="popup" class="liengrade">
<% Response.Write rs4("grade_libelle" )%>
</a> <% i = i+1
else
Response.Write ", " %> <a href="detail_fonction.asp?idgrade=<%=rs4("grade_code" )%>"
onclick="window.open('','popup','width=600,height=500,scrollbars=1'"
Target="popup" class="liengrade">
<%Response.Write rs4("grade_libelle" )%>
</a> <%end if
rs3.MoveNext
Loop%> </td>
<td></td>
</tr>
<tr>
<td> <font size="1" face="Arial, Helvetica, sans-serif"><strong>Collectivité
:</strong> <%Response.Write rs("offre_lieu" )& "</td><td></td></tr><tr></tr><tr>"
rs2.close
set rs2 = nothing
rs3.close
set rs3 = nothing
rs4.close
set rs4 = nothing
rs.MoveNext
Loop
%> </tr>
</table>
<%end if%> <p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
</td>
</tr>
<tr>
<td height="19"> </td>
<td height="19"> </td>
</tr>
<tr>
<td height="19" background="../hte%20loire/images/fond%20boutonbis.gif"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> Emplois</strong></font></td>
<td height="19"> </td>
</tr>
<tr>
<td height="19"> </td>
<td height="19"> </td>
</tr>
<tr>
<td height="21" colspan="2" valign="top">
<table width="129" border="0" cellspacing="0">
<tr>
<td width="124" height="21" background="../hte%20loire/images/fond%20boutonbis.gif"><font size="2" face="Arial, Helvetica, sans-serif"><strong> Concours</strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="19"> </td>
<td height="19"> </td>
</tr>
<tr>
<td height="20" valign="top" background="../hte%20loire/images/fond%20boutonbis.gif"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> Formulaires</strong></font></td>
<td height="20"> </td>
</tr>
<tr>
<td height="19"> </td>
<td height="19"> </td>
</tr>
<tr>
<td height="19" valign="top" background="../hte%20loire/images/fond%20boutonbis.gif"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong> Liens</strong></font></td>
<td height="19"> </td>
</tr>
<tr>
<td height="19"> </td>
<td height="19"> </td>
</tr>
<tr>
<td height="19" valign="top" background="../hte loire/images/fond boutonbis.gif"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"> <strong>Plan
du site</strong></font></td>
<td height="19"> </td>
</tr>
<tr>
<td height="19"> </td>
<td> </td>
</tr>
<tr>
<td height="19"> </td>
<td> </td>
</tr>
<tr>
<td height="19"> </td>
<td> </td>
</tr>
<tr>
<td height="19"> </td>
<td> </td>
</tr>
<tr>
<td height="39"> </td>
<td rowspan="2" background="../tronc commun/images/fond_tab.gif"> </td>
</tr>
<tr>
<td height="24" background="../tronc commun/images/fond_tab.gif"> </td>
</tr>
<tr>
<td height="30" background="../tronc commun/images/fond_tab.gif"> </td>
<td height="30" background="../tronc commun/images/fond_tab.gif"> </td>
<td height="30" align="right" valign="top" background="../tronc%20commun/images/fond%20tab2.gif">
<p align="right"> <img src="../tronc%20commun/images/cle%20acces.gif" width="29" height="30" align="absmiddle"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><strong>Acces
Adhérents</strong></font> </p></td>
<td valign="top"> </td>
</tr>
</table></td>
</tr>
</table>
