新闻动态
新闻动态
- 微信小程序 - 高级 - wx:for 与 wx:for-items 与 wx:key
- 制作并运营一款app需要icp许可证吗?
- 搭建vue项目完整步骤
- 单页应用和多页应用的区别
- ASP.net2.0中App_GlobalResources的用途
- C# 读取Excel时读取不到第一行的问题
- CentOS命令启动及CentOS命令启动网卡
- asp.net支付宝接口,付款部分
- fckeditor在ie9中不支持$=document.getElementById解决办法
- jQuery方法大全
联系我们
邮箱:
手机:15383239821
数据库
access中,用replace函数做替换,如何区分中文分号和英文分号
作者:
发布时间:2013-04-25
点击:
Function CheckStr(byVal ChkStr) '检查无效字符
Dim Str:Str=ChkStr
Str=Trim(Str)
If IsNull(Str) Then
CheckStr = ""
Exit Function
End If
Dim re
Set re=new RegExp
re.IgnoreCase =True
re.Global=True
re.Pattern="(\r\n){3,}"
Str=re.Replace(Str,"$1$1$1")
Set re=Nothing
Str = Replace(Str,"'","''")
Str = Replace(Str, "Select", "Select")
Str = Replace(Str, "join", "join")
Str = Replace(Str, "union", "union")
Str = Replace(Str, "where", "where")
Str = Replace(Str, "insert", "insert")
Str = Replace(Str, "delete", "delete")
Str = Replace(Str, "update", "update")
Str = Replace(Str, "like", "like")
Str = Replace(Str, "drop", "drop")
Str = Replace(Str, "create", "create")
Str = Replace(Str, "modify", "modify")
Str = Replace(Str, "rename", "rename")
Str = Replace(Str, "alter", "alter")
Str = Replace(Str, "cast", "cast")
CheckStr=Str
End Function
keyword=CheckStr(request("keyword"))
新闻资讯
-
2025-05-30select 选中事件 js
-
2018-11-14微信营销的技巧
-
2023-05-04PHP中private、public、protected的区别详解
-
2012-07-17小心友情链接遭连坐
-
2010-07-20SEO之歌
相关案例
