public Function RSQL(strChar)1 ?! ]7 f3 w* {, h% R
If strChar = "" or IsNull(strChar) Then RSQL = "":Exit Function& r5 B4 @: ^; ~& W7 H6 g5 t. ~
Dim strBadChar, arrBadChar, tempChar, I2 r) q- B2 j: W4 d6 d6 U0 s
strBadChar = "$,#,',%,^,&,?,(,),<,>,[,],{,},/,\,;,:," & Chr(34) & "," & Chr(0) & ""’注意这里过滤的是特殊字符 ‘Chr(34)对应的ASCII码是双引号。Chr(0)其实就是我们上传改包把空格(20)改成的00
" c: }/ b* J# c0 Z arrBadChar = Split(strBadChar, ","): p- z; Z/ I2 f, l& H
tempChar = strChar2 V2 i# l; n* u/ d8 _
For I = 0 To UBound(arrBadChar)
# M# ~3 N9 a4 w4 q* f. F& A* z tempChar = Replace(tempChar, arrBadChar(I), "") ‘将特殊字符过滤为空- L* w b* V7 f3 @
Next, Z# L& I( s. K9 m x& X
RSQL = tempChar
1 e# i* {, w: I& y+ XEnd Function& M6 C, {3 X" R( r
|