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>