Question

ASP从数据库获得的下拉列表值 传递到下一页

<!--#include file="conn2.asp" -->
<%
set rs=server.CreateObject("adodb.recordset")
sql="Select * from sh_shop where sh_dal<>null order by datetime desc"
rs.open sql,conn,3,1
%>
<table width="910" height="442" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="80" height="47"> </td>
<td width="780"> </td>
<td width="50"> </td>
</tr>
<tr>
<td height="350"> </td>
<td><form id="form1" name="form1" method="post" action="add_pp.asp">
<table width="416" height="149" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" align="center">添加商品品牌</td>
</tr>
<tr>
<td align="right">商品大类：</td>
<td>

<select name="dal" id="dal">
<%
do while not rs.eof

%>

<option value="<%=rs("id")%>"><%=rs("sh_dal")%></option>
<%
rs.movenext
loop

%>

想让<%=rs("sh_dal")%>的值传递到下一页~~进行SQL语句的判断~~
小弟 没分 不好意思了~~
经过努力 终于有分了~~~谁来解答啊？

Answer 1

<option name="sh" value="<%=rs("id")%>"><%=rs("sh_dal")%></option>
sh=request.form("sh")
response.write(sh)