D7 API documentation
What's New
Modules
Main module in old core
addSecondsToDateTime
castToChar
convertFromDb
convertToDb
forSql
formatDate
getAliasLength
getAscendingOrder
getCharToDateFunction
getColumnTypeByField
getConcatFunction
getConverter
getCurrentDateFunction
getCurrentDateTimeFunction
getDateToCharFunction
getDatetimeToDateFunction
getDescendingOrder
getFieldByColumnType
getIsNullFunction
getLeftQuote
getLengthFunction
getQueryDelimiter
getRightQuote
getSubstrFunction
getTopSql
prepareAssignment
prepareInsert
prepareMerge
prepareUpdate
quote
softCastTextToChar
getIsNullFunction
string public \Bitrix\Main\DB\SqlHelper::getIsNullFunction( string $expression, string $result );
This non-static method returns SQL function for testing database field or expressions against NULL value. When it is NULL then $result
will be returned.
All parameters are SQL unsafe.
Parameters
Parameter | Description | Version |
---|---|---|
$expression | Database field or expression for testing against NULL. | |
$result | Database field or expression to be returned if $expression is NULL. |
Examples
© «Bitrix24», 2001-2024
Up