急件!!关于ASP与JAVASCRIPT的值交换
目的是实现选者一个<select>中的一个值,在另一个<select>中现出相关内容,但要用数据库。type与type2是一对多关系,下面是部分代码:我想从 行业信息名中变换的info1.name.value值作为下面 该行业子类名:下的sql语句的判断条件,请问个位这麽办!
<td width="150" height="31">
<p align="right">行业信息名:
</td>
<td width="150" height="31">
<select size="1" name="name" onchange=javascript:info1.submit()>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from type",conn,3,3
rs.movefirst
while not rs.eof
response.write "<option value="&rs("cID")
response.write " selected "
response.write ">"&rs("cname")&"</option>"
rs.movenext
wend
rs.Close
%>
</select>
</td>
</tr>
<tr>
<td width="150" height="25">
<p align="right">该行业子类名:
<td width="150" height="25">
<select size="1" name="name">
<%
sql="select * from type2"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,3,3
rs2.movefirst
while not rs2.eof
response.write "<option value="&rs2("ID")
response.write " selected "
response.write ">"&rs2("t1name")&"</option>"
rs2.movenext
wend
rs2.Close
%>
</select>
</tr>