public Function RSQL(strChar)- O7 P' e5 D8 ~* ^( t% A! W
If strChar = "" or IsNull(strChar) Then RSQL = "":Exit Function
# \5 `: j8 n) J, G) |; f x3 B# k# d+ ` Dim strBadChar, arrBadChar, tempChar, I- J1 B! f/ o5 Y1 @* m
strBadChar = "$,#,',%,^,&,?,(,),<,>,[,],{,},/,\,;,:," & Chr(34) & "," & Chr(0) & ""’注意这里过滤的是特殊字符 ‘Chr(34)对应的ASCII码是双引号。Chr(0)其实就是我们上传改包把空格(20)改成的00" j! \) N5 I: _) q
arrBadChar = Split(strBadChar, ",")
. @+ S& e6 S; K! E$ }; s% Y- t* _ tempChar = strChar! O( U) m8 l+ j9 c' f! G
For I = 0 To UBound(arrBadChar)8 T, ^. x* P1 Y/ T
tempChar = Replace(tempChar, arrBadChar(I), "") ‘将特殊字符过滤为空
( Z8 A4 ~2 |5 g! }* N- [ Next
, ^& j% x7 o6 f2 j! L1 A RSQL = tempChar
8 T4 `; L! w: T7 ?* ^, dEnd Function
) ?! S3 H& Z! z* B& Q+ Y |