<%
'数据库连接conn
a=request("a")'获取查询值
set rs=conn.execute("select * fom [Purchase] 蔬菜 like '%"&a&"%' or 肉 like '%"&a&"%'")
do while not rs.eof
respone.write rs("蔬菜")&"--"&rs("肉")
rs.movenext
loop
set rs=nothing
%>
楼主看这样行不行:
<form method="post">
<input type="text" name="a">请输入 菜名 或者 肉名<br>
<input type="submit" value="提交">
</form>
<%
access数据库的链接不记得,我是菜鸟,楼主百度一下吧
aa=trim(request.form("a"))
set rs=server.CreateObject("adodb.recordset")
sql="select * from purchase where 菜名='&aa&' or 肉名='aa'"
rs.open sql,连接字符串,1,1
if rs.eof or rs.bof then
response.Write("无人购买")
else
response.Write("rs("采购者")")
rs.close
set rs=nothing
%>
如
菜名为:cm
肉名为:rm
<%
key=trim(request("key_query"))
set rs=conn.execute ("select * from table where cm like '%"&key&"%' or rm like '%"&key&"%'" )
if not rs.eof then
response.write rs("采购者")
end if
%>