我感觉你是理解错了我的意思了吧::
<select size="1" class="style3" id="select2" name=select >
<option selected value=出租转让 >出租转让</option>
<option value=积压物资>积压物资</option>
<option value=商务合作>商务合作</option>
<option value=求租求购>求租求购</option>
</select> //这个select 的值供下面的select使用
<select name="scid" size="1">
<%
dim bc
bc='select.value' //使用该值
set rs0 =server.createobject("adodb.recordset")
sql0="select * from no1 where "
no1name='"&bc&"'"
rs0.open sql0,conn,1,1
set rs =server.createobject("adodb.recordset")
sql="select * from no2 where no1id='"&rs0("no1id")&"'"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.Write "<option selected>请选择类别</option>"
else
do while not rs.eof
response.Write "<option value="&rs("no2id")&">"&rs("no2name")&"</option>"
rs.movenext
Loop
end if
%>
</select>
<%
rs.close
rs0.close
set rs=nothing
set rs0=nothing
%>
[此贴子已经被作者于2005-11-25 13:39:02编辑过]