Question

asp 模糊查询问题

表单部分
<form action="news.asp" method="post" name="search">
<input class="input1" value="" id="myinput" type="text" name="kword" />
<input type="submit" class="button1" value="" />
</form>

news.asp代码部分
kword=request.form("kword")
set rs=server.createobject("adodb.recordset")
if kword<>""then
exec="select * from news where title like '%"&kword&"%'"
end if
rs.open exec,conn,1,1
没法模糊查询 在线求救

Answer 1

kword=request.form("kword")
set rs=server.createobject("adodb.recordset")
exec = "select * from news"
if kword<>""then
exec = exec&" where title like '%"&kword&"%' "
end if
rs.open exec,conn,1,1
if rs.eof then
Response.write "未找到相应内容"
Else
'这里是你的代码
end if

Answer 2

试试这样是否可以
if kword<>""then
exec="select * from news where title like '%" & kword & "%' "
end if

追问

不是一样的吗 有区别吗？