Class AfMssqlDbHelper
A generic database helper for SQL Server. If you are using an SQL Server version of 2012 or later, you should instead use the more robust AfMssql2012DbHelper class, by overriding the $driverMap property in the configuration of the advanced filters extension.
- CComponent
- AfBaseDbHelper
- AfMssqlDbHelper
Direct known subclasses
Package: advancedfilters\dbhelpers
Author: Keith Burton kburton@kappasoft.net
Located at dbhelpers/AfMssqlDbHelper.php
Author: Keith Burton kburton@kappasoft.net
Located at dbhelpers/AfMssqlDbHelper.php
Methods summary
public
string
|
#
convertExpressionToDecimal( string $dbExpression, integer $numDigits, integer $decimalPlaces, integer $nonNumericResultValue )
Provides conversion to decimal for SQL Server versions earlier than 2012. |
public
boolean
|
#
checkRegex( CDbConnection $dbConnection, string $regex )
Checks regular expression syntax using the very limited PATINDEX function. Documentation for this function's syntax can be found on MSDN. |
public
|
#
addRegexCondition( CDbCriteria $criteria, string $columnExpression, string $regex, boolean $invertLogic )
Adds a regex condition using the very limited PATINDEX function. Documentation for this function's syntax can be found on MSDN. |
Methods inherited from AfBaseDbHelper
convertEmptyStringToNull()
,
convertNullToEmptyString()