Class AfMssql2012DbHelper

This database helper class can be used for SQL Server versions 2012 and later. It offers more robust numeric conversion than the generic SQL Server helper.

To use this class, override the extension's $driverMap property in your application config.

CComponent

AfBaseDbHelper

AfMssqlDbHelper

AfMssql2012DbHelper

Package: advancedfilters\dbhelpers
Author: Keith Burton kburton@kappasoft.net
Located at dbhelpers/AfMssql2012DbHelper.php

Methods summary

`public string`	# `convertExpressionToDecimal( string $dbExpression, integer $numDigits, integer $decimalPlaces, integer $nonNumericResultValue )` Overrides the generic SQL Server implementation to make use of the TRY_CAST function added in 2012. This is a more robust solution and should be used if you only need to deal with SQL Server versions from 2012 onwards. Overrides the generic SQL Server implementation to make use of the TRY_CAST function added in 2012. This is a more robust solution and should be used if you only need to deal with SQL Server versions from 2012 onwards. Parameters `$dbExpression` the expression to update. `$numDigits` the maximum number of digits that the decimal number should contain. `$decimalPlaces` the number of decimal places that the resulting decimal should have. `$nonNumericResultValue` the integer value to use if an expression isn't recognised as a number. This can also be null. Returns `string` the updated expression. Overrides `AfMssqlDbHelper::convertExpressionToDecimal`

Methods inherited from AfMssqlDbHelper

addRegexCondition(), checkRegex()

Methods inherited from AfBaseDbHelper

convertEmptyStringToNull(), convertNullToEmptyString()

Packages

Classes

Class AfMssql2012DbHelper

Methods summary

Parameters

Returns

Overrides

Methods inherited from AfMssqlDbHelper

Methods inherited from AfBaseDbHelper

Magic methods summary