sql
来源:互联网 发布:淘宝刷单靠谱吗 编辑:程序博客网 时间:2024/06/16 09:06
'替换SQL语句中的特殊字符 ![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif)
Function SqlFix()Function SqlFix(ByVal str As String) As String
Dim strTmp
If str & "" = "" Then
Exit Function
End If
strTmp = Replace(str, "'", "''")
strTmp = Replace(strTmp, """", "")
strTmp = Replace(strTmp, ";", "")
strTmp = Replace(strTmp, "&", "")
strTmp = Replace(strTmp, " ", "")
strTmp = Replace(strTmp, " ", "")
strTmp = Replace(strTmp, "%20", "")
strTmp = Replace(strTmp, "--", "")
strTmp = Replace(strTmp, "==", "")
strTmp = Replace(strTmp, "<", "")
strTmp = Replace(strTmp, ">", "")
strTmp = Replace(strTmp, "%", "")
SqlFix = strTmp
End Function
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif)
![](http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockEnd.gif)
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- sql
- SQL (-)
- sql
- SQL
- SQL
- SQL
- sql
- sql
- sql
- sql
- SQL
- sql
- 新的开始
- 在嵌入式开发平台中实现USB设备的自动挂载
- html:select 标签下拉项不让选择的一个笨办法
- VSS的Invalid handle错误
- Error configuring application listener of class org.springframework.web.context.ContextLoaderListener
- sql
- General Overview of The System(一)
- 打印设置(脚本)
- VC图像处理(转)
- Servlet及JSP中的多线程同步问题
- 如何在64系统上监视32位模式下ASP.NET程序的性能
- 摸着石头过河----fcitx3输入法的安装!
- 菜鸟起飞
- 在Windows 2003 64位下ASP无法连接Access数据库的问题