UC知道asp精确搜索改模糊搜索
来源：百度知道 编辑：UC知道 时间：2024/05/30 00:57:45
请高手帮忙把这段代码给为模糊搜索
刚忘了贴了~~现在补上
If KindId="0" Then
strSql="Select * From book Order By Submitdate Desc"
Else
strSql="Select * From book Where KindId=" & KindId & " Order By Submitdate Desc"
End If
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open strSql,db,1
刚忘了贴了~~现在补上
If KindId="0" Then
strSql="Select * From book Order By Submitdate Desc"
Else
strSql="Select * From book Where KindId=" & KindId & " Order By Submitdate Desc"
End If
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open strSql,db,1
If KindId="0" Then
strSql="Select * From book Order By Submitdate Desc"
Else
strSql="Select * From book Where KindId like %" & KindId & "% Order By Submitdate Desc"
End If
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open strSql,db,1
此为正确答案
请把SQL语句贴出来啊？
把=号 改为 like就行了
"Select * From book Where KindId like '"& KindId &"'"