神马品牌网瑞金为什么可以建机场:大家帮我看看这个代码有什么错误呢?就是搜索的时候英文单词间有空格就出不了!
来源：百度文库 编辑：神马品牌网 时间：2024/05/11 03:22:51
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,"'","‘"),"<","<"),">",">")