menu+SQl

menu+SQl - HTML/CSS - Programmation

Marsh Posté le 26-06-2003 à 14:56:52    

pourquoi un truc comme ça ne fonctionne pas??? La requête sql du 2nd select ne revoie rien!!!
 
 
<body>
 
<form name="formu">
 
<select name="signature" >
<%set rs=conn.execute("select distinct signature from hierarchie0" )
while not rs.eof %>
<option><%=  response.write(rs("signature" )&"<br>" )%></option>
<% rs.movenext
  wend %>
</select>
 
<br>
 
<select name="brand">
<%
set rs=conn.execute("select distinct brand from hierarchie0 where
signature='+document.formu.signature.options[document.formu.signature.select
edIndex].text+'" )
 
while not rs.eof %>
<option><%=  response.write(rs("brand" )&"<br>" )%></option>
<%rs.movenext
  wend%>
 
</select>
</form>
</BODY>
</HTML>

Reply

Marsh Posté le 26-06-2003 à 14:56:52   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed