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

来源:百度知道 编辑:UC知道 时间:2024/05/14 10:04:28
<%
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
%>
我不知道这个错在那呀
冻结大侠,不好意思麻烦您了,我还是不怎么明白,能再详细点吗,谢谢您>

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

<%
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
%>