关于sql 查询的问题？急....

[firstname]

我想做一个产品查询，当选择公司时，下面的下拉菜单列出相应的产品，当点产品时进行查询
<select name="select3" class="wz">
<option>请选择公司...</option>
<option>xxxx</option>
<option>sssss</option>
<option>fffff</option>
</select>
<select name="select4" class="wz">
<option>请选择产品...</option>
<option>dddd</option>
<option>jjjj</option>
</select>
我应该怎样来实现，能给我说说吗？
我的表结构是：
products: id,Co_name(公司名)，productsname

[cshadow]

a.asp
<form Action="b.asp" Method="POST">
<select name="select3" class="wz">
<option>请选择公司...</option>
<option>xxxx</option>
<option>sssss</option>
<option>fffff</option>
</select>
<select name="select4" class="wz">
<option>请选择产品...</option>
<option>dddd</option>
<option>jjjj</option>
</select>
<input Type="submit" Value="提交" name="B1" >

</form>


b.asp
省略连接数据库
Co_name=request("select3")
productsname=request("select4")
省略验证
set rs=server.createobject("adodb.recordset")
sql="select * from products "
rs.open sql,conn,1,3
rs.addnew
rs("Co_name")=Co_name
rs("productsname")=productsname
rs.update
rs.close

[lly1111]

<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();

subcat[0] = new Array("ASP基础","1","1");

subcat[1] = new Array("ASP应用","1","2");

subcat[2] = new Array("ASP技巧","1","3");

subcat[3] = new Array("性能优化","2","4");

subcat[4] = new Array("安全加密","2","5");

subcat[5] = new Array("XML相关","2","6");

subcat[6] = new Array("全文检索","2","7");

subcat[7] = new Array("客户端相关","2","8");

subcat[8] = new Array("打印相关","1","9");

subcat[9] = new Array("数据库相关","1","10");

subcat[10] = new Array("入门教程","1","11");

onecount=11;

function changelocation(locationid)
{
document.myform.Nclassid.length = 0;

var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.Nclassid.options[document.myform.Nclassid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}

}
</script>

<form method="post" name="myform" action="file://///Cjp2000/qqhaer2/ru_query.asp">
<select name="classid" onChange="changelocation(document.myform.classid.options[document.myform.classid.selectedIndex].value)" size="1">
<option selected value="">请选择公司</option>

<option value="1">xxxx</option>


<option value="2">sssss</option>


</select>

<select name="Nclassid">
<option selected value="">请选择产品</option>
</select>
<input type="text" name="keyword" class=smallinput size=10 value="关键字" maxlength="50">
<input type="submit" name="Submit" value="搜索">
</form>

[xjbx]

<script language=javascript>

function sm(){
this.document.form1.submit();
}

</script>
<form name=form1 method="POST" ation="resu.asp">
<select name="select3" class="wz">
<option>请选择公司...</option>
<option>xxxx</option>
<option>sssss</option>
<option>fffff</option>
</select>
<select name="select4" class="wz" onchange="sm()">
<option>请选择产品...</option>
<option>dddd</option>
<option>jjjj</option>
</select>

</form>

然后在resu.asp接受这个页面提交的数据（resu.asp文件你自己写吧！）

[bestpeaker]

在select4的onchange事件中加入以下代码：
window.open "search.asp?Co=" & select3.options(select3.selectedIndex).text & "&Product=" & select4.options(select4.selectedIndex).text

然后在search.asp页面中用以下查询语句：
strCo=Request.QueryString("Co")
strProduct=Request.QueryString("Product")
strSQL="select * from products where Co_name='" & strCo & "' and productsname='" & strProduct & "'"

rs.open strSQL,数据库连接,3,1

[naonaozhang]

在影子写的代码中的<form>中再加上一个参数action="b.asp"，这样提交后才会执行b.asp的代码。也就可以将内容存入数据库了。如果是查询，sql语句这样写：sql="select * from biao where Co_name='"&request.form("name3")&"'".这样应该就可以了。显示的时候直接用查询到的字段。

[baisun]

Co_name=request("select3")
productsname=request("select4")
set rs=server.createobject("adodb.recordset")
sql="select * from products where Co_name="&Co_name&" and productsname="&productsname
rs.open sql,conn,1,1

response.write rs("Co_name")

[firstname]

我这样写，但是执行查询后不能转到相应的子页面
<form name="form1" method="post" action="index.asp">
<select name="select3" class="wz">
<option>请选择公司...</option>
<option>xxxx</option>
<option>ddd</option>
<option>fff</option>
</select>
<%set rs1=server.createobject("ADODB.recordset")
sql="select * from products where Co_name='"&request("select3")&"'"
rs1.open sql,conn,3%>
<img src="images/search.gif" width="15" height="15" onclick=javascript:form1.submit(); border="0">
</form>
</td>
</tr>
<tr>
<td height="24" align="center">
<form name="form2" method="post" action="index.asp">
<select name="select4" class="wz">
<option>请选择产品...</option>
<%do while not rs1.eof %>
<option><%=rs1("productname")%></option>
<%rs1.movenext loop %>
</select>
<%
set rs2=server.createobject("ADODB.recordset")
sql1="select * from products where productname='"&request("select4")&"'"
rs2.open sql1,conn,3%>
<%if not rs2.eof then
response.redirect "../newsystem/dailcontent_p.asp?id=<%=rs2("id")%>"
end if %>

<img src="images/search.gif" width="15" height="15" border="0" onclick=javascript:form2.submit();>
</form>
出错就在response.redirect ""这行，我不知该怎样写，产品详细信息在文件dailcontent_p.asp中，我直接写成response.redirect "dailcontent_p.asp"
出错：
ADODB.Field 错误 '80020009'

BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。

/newsystem/dailcontent_p.asp，行0

[nickycheng]

<%
if not rs2.eof then
response.redirect "../newsystem/dailcontent_p.asp?id=" &rs2("id")

end if

%>

[cshadow]

dailcontent_p.asp有错误啊

[firstname]

我试用lly1111()老兄的方法，当我调用我的查询文件时出错，我的查询文件没有错误 。
我换一种简单的文本框输入我要查询的东西，就没有一点问题，只要用lly1111()说的方法，查询文件就出错