public Function RSQL(strChar); x0 U; ~# v8 p2 t
If strChar = "" or IsNull(strChar) Then RSQL = "":Exit Function5 J/ y" i3 q4 C1 L# P
Dim strBadChar, arrBadChar, tempChar, I
5 F6 C4 o) t! q% l3 g" L strBadChar = "$,#,',%,^,&,?,(,),<,>,[,],{,},/,\,;,:," & Chr(34) & "," & Chr(0) & ""’注意这里过滤的是特殊字符 ‘Chr(34)对应的ASCII码是双引号。Chr(0)其实就是我们上传改包把空格(20)改成的00
7 ]2 G9 O' ^4 `( Z' z" f; K- b- d arrBadChar = Split(strBadChar, ",")
5 I1 T! l' L" a) H8 l$ t- k" W tempChar = strChar
- e$ W8 @) k" K& f/ z For I = 0 To UBound(arrBadChar)
% v' A) F% H M" ]0 I tempChar = Replace(tempChar, arrBadChar(I), "") ‘将特殊字符过滤为空
# p6 n( T* n) }1 r: B; f8 y8 @ Next
, n# ~. U$ i5 v8 i, Y$ ^) Y RSQL = tempChar
' \: }6 p# v" A3 aEnd Function
/ u- c8 o) M0 P |