比较不错的asp单表单字段多条件查询

        Loop
End IF        


SearshSQL=MySql

end function

Function SqlEncode(Str)                '格式化字符串
str=replace(str,"　"," ")        '先把左右的全角空格替换成半角空格
str=trim(str)
str=replace(str,"["," ")
str=replace(str,"';"," ")
str=replace(str,"'"," ")
str=replace(str,"_"," ")
str=replace(str,"%"," ")
str=replace(str,"+"," ")
str=replace(str,"　"," ")
sqlencode=str
end function
%>
<%
sql=SearshSQL("article","coments","萝卜＋白菜　狗熊") ＋"order by..(排序)"
Set rs=Server.Createobject("ADODB.RECORDSET")
rs.Open sql,conn,1,1
if not rs.eof then

下面的自己写

您可能感兴趣的文章:

用扩展方法优化多条件查询(不定条件查询)PHP实现多条件查询实例代码多条件查询的程序PHP组合查询多条件查询实例代码一个简单实现多条件查询的例子php通过数组实现多条件查询实现方法(字符串分割)