28/05/2002, 09:42
|
| | | Fecha de Ingreso: abril-2002 Ubicación: Madrid
Mensajes: 117
Antigüedad: 23 años Puntos: 0 | |
| Re: Cargar Combos (SELECT) sin recargar la página
carga los 2 select en sendos arrays de javascript
<html>
<head>
<%
set objConn=server.createobject("adodb.connection ")
objConn.open("Provider=Microsoft.Jet.OLEDB.4. 0;Data Source="&server.mappath("cars.mdb&qu ot;))
set rs=objConn.execute("SELECT Makes.MakeID, Makes.Make, Models.Model FROM Makes INNER JOIN Models ON Makes.MakeID = Models.MakeID")
aData = rs.getrows
rs.close: set rs=nothing
objConn.close: set objConn=nothing
intID = 0
strListBox = "<select class=""listbox"" name=""makes"" onChange=""swapModel(this.form)"&qu ot;><option SELECTED value=""none"">Please Select A Make</option>"
response.write "<script>"&vbcrlf
for i = 0 to ubound(aData,2)
if cint(aData(0,i)) <> intID then
intCount = 0
intID = aData(0,i)
strListBox = strListBox &"<option value="""&intID&"" ;">"&aData(1,i)&"</option>"
response.write "a"&aData(0,i)&" = new Array();" & vbcrlf
end if
response.write "a"&intID&"["&intCount&"] = '"&aData(2,i)&"';"&vbcr lf
intCount = intCount +1
next
strListBox = strListBox & "</select>"
response.write "</script>"&vbcrlf
%>
<script>
function swapModel(frm){
if(frm.makes.options[frm.makes.options.selectedIndex].value!='none'){
var aArray = eval("a"+frm.makes.options[frm.makes.options.selectedIndex].value);
frm.models.options.length = aArray.length + 1;
for(i = 0;i<aArray.length;i++){
frm.models.options[i+1].text = aArray;
}
}
}
</script>
</head>
<body>
<form><p class="text"><%=strListBox%>
<select name="models" size="1" class="listbox">
<option value="none" SELECTED>Please Select A Model</option>
</select></form>
</body>
</html>
|