高考问答鹁鸪的古诗:大家帮我看看这个代码有什么错误呢?就是搜索的时候英文单词间有空格就出不了!
来源：百度文库 编辑：高考问答 时间：2024/05/04 19:18:34
keyword=trim(request("keyword"))
if keyword<>"" then
keyword=replace(replace(replace(replace(keyword,"'","‘"),"<","<"),">",">")," "," ")
end if
if keyword<>"" then
select case strField
case "Title_en"
sqlSearch= "select * from Product where Passed=True and Title_en like '%" & keyword & "%' "
case "Content_en"
sqlSearch=" select * from Product where Passed=True and Content_en like '%" & keyword & "%' "
case else
sqlSearch= "select * from Product where Passed=True and Title_en like '%" & keyword & "%' "
end select
if keyword<>"" then
keyword=replace(replace(replace(replace(keyword,"'","‘"),"<","<"),">",">")," "," ")
end if
if keyword<>"" then
select case strField
case "Title_en"
sqlSearch= "select * from Product where Passed=True and Title_en like '%" & keyword & "%' "
case "Content_en"
sqlSearch=" select * from Product where Passed=True and Content_en like '%" & keyword & "%' "
case else
sqlSearch= "select * from Product where Passed=True and Title_en like '%" & keyword & "%' "
end select
第三行改为
keyword=replace(replace(replace(keyword,"'","‘"),"<","<"),">",">")