RAFFRAICHIR UNE LISTE EN FONCTION D'UNE AUTRE

<cfquery name="qclassification" datasource="GSB">
SELECT f_rubriques.F_CLASSIFICATION, f_rubriques.FR_LIBELLE FROM f_rubriques WHERE 0 = 0
<cfif isdefined("form.rubrique")>
  and left(f_rubriques.F_CLASSIFICATION,2) = #form.rubrique# 
</cfif>
ORDER BY f_rubriques.FR_LIBELLE 
</cfquery>


<!-- ------------------------------------------------------------------
<cfform action="" method="post" name="frubrique">
   <select name="rubrique" id="rubrique" onChange="document.forms[0].submit()">
       <option selected>Choisissez une rubrique</option>
       <option value="01">Musique</option>
       <option value="02">Agences </option>
       <option value="03">Artistes</option>
       <option value="04">Cinema</option>
   </select>
</cfform> 

<cfform action="resultat.cfm?#client.URLToken#" method="post" name="f_resultat" target="_self" onsubmit="pageLoad_onsubmit()"> 
<b>Classification</b></td>
<td width="32%">
<select name="classification" id="classification">
       <cfoutput query="qclassification"> 
       <option value="#qclassification.F_CLASSIFICATION#">#qclassification.FR_LIBELLE#</option>
       </cfoutput> 
</select>
</td>
...