繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > asp实现限制搜索的关键字的函数
- ASP
- ADO如何提供异动功能？（BIG5）
- 从数据库中动态选取下拉列表的方法
- 数 据 库 设 计 经 验 谈
- 用SQL实现分布式数据复制
- NT4的ODBC与SQL7相连，不支持中文？
- 大部分ADO的错误码对应的含义
- ASP+中取代ASP的RS(Remote Scripting)技术的Framework
- 利用Page.IsPostBack属性保持用户输入的Framework
- 用VB6读写数据库中的图片
- VisualInterDev6.0七种实现分页显示的方法
- 利用ASP获得图象的实际尺寸的示例
- 5个实用的ASP网站功能（GIB5）
- 在ＡＳＰ中用集合成批操作数据库
- 用asp管理sql server数据库
- 用asp处理access数据库
- 使用速度更快的OLEDB取代ODBC连结
- 对Query字段进行Encode操作的一点看法
- 用ASP语言实现对SQL SERVER 数据库的操作
- Microsoft SQL Server 7.0 备份及恢复相关问题
- Microsoft SQL Server 7.0数据库升级转换问题
ASP 中的 asp实现限制搜索的关键字的函数
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 231 ::
收藏到网摘: n/a
<%
'******************************
'函数：CheckQuery(ByVal str)
'参数：str ----搜索的字符串
'作者：阿里西西
'日期：2007/7/15
'描述：限制搜索的关键字
'示例：CheckQuery(str)
'******************************
Public Function CheckQuery(ByVal str)
Dim FobWords, i, keyword
keyword = str
On Error Resume Next
FobWords = Array(91, 92, 304, 305, 430, 431, 437, 438, 12460, 12461, 12462, 12463, 12464, 12465, 12466, 12467, 12468, 12469, 12470, 12471, 12472, 12473, 12474, 12475, 12476, 12477, 12478, 12479, 12480, 12481, 12482, 12483, 12485, 12486, 12487, 12488, 12489, 12490, 12496, 12497, 12498, 12499, 12500, 12501, 12502, 12503, 12504, 12505, 12506, 12507, 12508, 12509, 12510, 12532, 12533, 65339, 65340)
For i = 1 To UBound(FobWords, 1)
If InStr(keyword, ChrW(FobWords(i))) > 0 Then
CheckQuery = False
Exit Function
End If
Next
FobWords = Array("~", "!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "_", "+", "=", "`", "[", "]", "{", "}", ";", ":", """", "'", "<", ">", ".", "/", "\", "|", "?", "about", "after", "all", "also", "an", "and", "another", "any", "are", "as", "at", "be", "because", "been", "before", "being", "between", "both", "but", "by", "came", "can", "come", "could", "did", "do", "each", "for", "from", "get", "got", "had", "has", "have", "he", "her", "here", "him", "himself", "his", "how", "if", "in", "into", "is", "it", "like", "make", "many", "me", "might", "more", "most", "much", "must", "my", "never", "now", "of", "on", "only", "or", "other", "our", "out", "over", "said", "same", "see", "should", "since", "some", "still", "such", "take", "than", "that", "the", "their", "them", "then", "there", "these", "they", "this")
keyword = Left(keyword, 100)
keyword = Replace(keyword, "!", " ")
keyword = Replace(keyword, "]", " ")
keyword = Replace(keyword, "[", " ")
keyword = Replace(keyword, ")", " ")
keyword = Replace(keyword, "(", " ")
keyword = Replace(keyword, " ", " ")
keyword = Replace(keyword, "-", " ")
keyword = Replace(keyword, "/", " ")
keyword = Replace(keyword, "+", " ")
keyword = Replace(keyword, "=", " ")
keyword = Replace(keyword, ",", " ")
keyword = Replace(keyword, "'", " ")
For i = 0 To UBound(FobWords, 1)
If keyword = FobWords(i) Then
CheckQuery = False
Exit Function
End If
Next
CheckQuery = True
End Function
%>
评论 (0) All
