[求助]关于下拉列表传值的问题 - ASP技术论坛

得分:0

<html>
<body>
<% ID=request.form("idA")%>
<%
dim con,DBPath
set con=server.CreateObject("ADODB.Connection")
DBPath=server.MapPath("data.mdb")
con.open "driver={Microsoft Access Driver(*.mdb)};dbq="&DBPath
set rs=server.CreateObject("ADODB.Recordset")
sql="select * from data"
sql=sql & "where 产品编号 like '%"& ID &"%'"
con.execute sql
rs.open sql,con,1,3
%>
<% if not rs.eof and not rs.bof then %>
<table width="861" height="71" border="1">
<tr>
<th width="64" height="35">产品编号</th>
<th width="61" scope="col">产品名称</th>
<th width="33" scope="col">主频</th>
<th width="49" scope="col">单双核</th>
<th width="32" scope="col">内存</th>
<th width="77" scope="col">硬盘</th>
<th width="77" scope="col">光驱</th>
<th width="77" scope="col">显卡</th>
<th width="77" scope="col">显示器</th>
<th width="77" scope="col">操作系统</th>
<th width="77" scope="col">类型</th>
<th width="84" scope="col">价格</th>
</tr>
<tr>
<td height="28"> <%= rs("ID") %></td>
<td> <%= rs("name") %></td>
<td> <%= rs("zp") %></td>
<td> <%= rs("dsh") %></td>
<td> <%= rs("nc") %></td>
<td> <%= rs("yp") %></td>
<td> <%= rs("xk") %></td>
<td> <%= rs("xsq") %></td>
<td> <%= rs("system") %></td>
<td> <%= rs("lx") %></td>
<td> <%= rs("jg") %></td>
<td> <%= rs("jg1") %></td>
</tr>
</table>
</body>
</html>
<% else %>
对不起,没有您要查找的数据
<%
rs.close
set rs=nothing
con.close
set con=nothing
%>
<% end if %>
如果是这样不应该该缺少end