Question

请问在asp中如何用select where in 语句实现多个查询呀,谢谢

<%
h_no=request.Form("h_no")
set rs=server.createobject("adodb.recordset")
sql="select * from hw where h_no in ("@ar")"
rs.Open sql,conn,1,1
if rs.EOF and rs.BOF then
Response.Write "当前没有这个单~~~~~~~~~~"
else
%>
我不知道这个错在那呀
冻结大侠,不好意思麻烦您了,我还是不怎么明白,能再详细点吗,谢谢您>

Answer 1

sql="select * from hw where h_no in ("&ar&")"

Answer 2

<%
h_no=request.Form("h_no")
set rs=server.createobject("adodb.recordset")
sql="select * from hw where h_no ="%@ar%""
rs.Open sql,conn,1,1
if rs.EOF and rs.BOF then
Response.Write "当前没有这个单~~~~~~~~~~"
else
%>