ragazzi ma è davvero dificile quetsa cosa
codice:
<%@LANGUAGE="VBSCRIPT"%>
<html><head>
<title>Esempio - Select dinamiche</title>

<% 
sql="select * from negozi"
set rs=conn.execute(sql)
 %>
<script type="text/javascript">
var regiondb = new Object()
<% while rs.eof=false %>
regiondb["<%= rs("id_negozio") %>"] = [{value:"<%= rs("id_negozio") %>," text:"<%= rs("indirizzo") %>"}];
<% 
rs.movenext 
wend
rs.close
set rs=nothing
%> 

function setCities(chooser) {
    var newElem;
    var where = (navigator.appName == "Microsoft Internet Explorer") ? -1 : null;
    var cityChooser = chooser.form.elements["città"];
    while (cityChooser.options.length) {
        cityChooser.remove(0);
    }
    var choice = chooser.options[chooser.selectedIndex].value;
    var db = regiondb[choice];
    
    if (choice != "") {
        for (var i = 0; i < db.length; i++) {
            newElem = document.createElement("option");
            newElem.text = db[i].text;
            newElem.value = db[i].value;
            cityChooser.add(newElem, where);
        }
    }
}


</script>
</head>


<body>
<h1>Esempio - Select dinamiche</h1>
<hr> 
<form name="form">
Invia la richiesta a: 
<select name="continente" onchange="setCities(this)">
<option value="" selected="selected">Seleziona un continente:</option>
<% sql="select * from negozi"
set rs=conn.execute(sql) %>
<% do while not rs.eof %>
<option value="<%= rs("id_negozio") %>"><%= rs("ragione_sociale") %></option>
<% rs.movenext %>
<% loop %>
</select> 
<select name="città">
</select>
</form>