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语句的判断~~

每次我得到的是ID的值~是数字~~

请高手帮忙 急啊~~
http://zhidao.baidu.com/question/48363950.html 这也是我提的问题~~没人回答~~有好的答案~我把这的分也给他~另外再加分50以上
问题是JS 我 不会~~我 希望高手 给段代码

Answer 1

<!--#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" onchange="location.href=('***.asp?id='+this.options[this.selectedIndex].value);">
<%
do while not rs.eof

%>

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

%>
把***替换成你要转到的页面，并在该页面用Requeset.QueryString("id")提取该值

QQ 165368576

Answer 2

JS实现