Question

set rs = conn.Execute(sql) 至少一个参数没有被指定值，这是说rs没有被指定，为什么没被指定

第一页
<% ids=rs("zhongjian")
text1= "/search.asp?ID="&ids&"&Submit322=%CB%D1+%CB%F7"
Response.Redirect text1

%>

第二页
<%
dim sql,rs
sql = "select * from Company where zhongjian="+request.QueryString("ID")+""
set rs = conn.Execute(sql)
if not rs.eof then
%>
》》》》》》》》》》》我找到原因了《《《《《《《《《《《《《《
sql = "select * from Company where zhongjian="+request.QueryString("ID")+""
这句话错了。
里边的ID是字符串，所以"+request.QueryString("ID")+"应该写成‘"+request.QueryString("ID")+"’

Answer 1

变量声明了啊,而且没有用option explicit
sql是没错的,我用access执行了查询
dim rs_shoujianren,sql_shoujianren
sql_shoujianren="select id,customerid from [customer] order by customerid"
set rs_shoujianren=conn.execute(sql_shoujianren)
'set rs_shoujianren=conn.execute("select id,customerid from [customer] order by customerid")