Propel API
Class

DBSQLSRV

class DBSQLSRV extends DBMSSQL

This is used to connect to a MSSQL database using pdo_sqlsrv driver.

Constants

ID_METHOD_NONE

ID_METHOD_AUTOINCREMENT

ID_METHOD_SEQUENCE

Methods

setCharset(PDO $con, $charset)

The toUpperCase(in $in)

This method is used to ignore case.

 from DBMSSQL
The ignoreCase(in $in)

This method is used to ignore case.

 from DBMSSQL
string concatString(string $s1, string $s2)

Returns SQL which concatenates the second string to the first.

 from DBMSSQL
string subString(string $s, int $pos, int $len)

Returns SQL which extracts a substring.

 from DBMSSQL
string strLength(string $s)

Returns SQL which calculates the length (in chars) of a string.

 from DBMSSQL
quoteIdentifier($text)

from DBMSSQL
quoteIdentifierTable($table)

from DBMSSQL
random($seed = null)

from DBMSSQL
applyLimit($sql, $offset, $limit)

Simulated Limit/Offset This rewrites the $sql query to apply the offset and limit.

 from DBMSSQL
cleanupSQL($sql, array $params, Criteria $values, DatabaseMap $dbMap)

initConnection(PDO $con, array $settings)

bindValue(PDOStatement $stmt, $parameter, $value, ColumnMap $cMap)

Details

at line 33
public setCharset(PDO $con, $charset)

Parameters

PDO $con
$charset

See also

parent::setCharset()

in DBMSSQL at line 34
public The toUpperCase(in $in)

This method is used to ignore case.

Parameters

in $in The string to transform to upper case.

Return Value

The upper case string.

in DBMSSQL at line 45
public The ignoreCase(in $in)

This method is used to ignore case.

Parameters

in $in The string whose case to ignore.

Return Value

The string in a case that can be ignored.

in DBMSSQL at line 57
public string concatString(string $s1, string $s2)

Returns SQL which concatenates the second string to the first.

Parameters

string $s1 String to concatenate.
string $s2 String to append.

Return Value

string

in DBMSSQL at line 70
public string subString(string $s, int $pos, int $len)

Returns SQL which extracts a substring.

Parameters

string $s String to extract from.
int $pos Offset to start from.
int $len Number of characters to extract.

Return Value

string

in DBMSSQL at line 81
public string strLength(string $s)

Returns SQL which calculates the length (in chars) of a string.

Parameters

string $s String to calculate length of.

Return Value

string

in DBMSSQL at line 89
public quoteIdentifier($text)

Parameters

$text

See also

DBAdapter::quoteIdentifier()

in DBMSSQL at line 97
public quoteIdentifierTable($table)

Parameters

$table

See also

DBAdapter::quoteIdentifierTable()

in DBMSSQL at line 106
public random($seed = null)

Parameters

$seed

See also

DBAdapter::random()

in DBMSSQL at line 118
public applyLimit($sql, $offset, $limit)

Simulated Limit/Offset This rewrites the $sql query to apply the offset and limit.

some of the ORDER BY logic borrowed from Doctrine MsSqlPlatform

Parameters

$sql
$offset
$limit

See also

DBAdapter::applyLimit()

at line 50
public cleanupSQL($sql, array $params, Criteria $values, DatabaseMap $dbMap)

Parameters

$sql
array $params
Criteria $values
DatabaseMap $dbMap

See also

parent::cleanupSQL()

at line 23
public initConnection(PDO $con, array $settings)

Parameters

PDO $con
array $settings

See also

parent::initConnection()

at line 73
public bindValue(PDOStatement $stmt, $parameter, $value, ColumnMap $cMap)

Parameters

PDOStatement $stmt
$parameter
$value
ColumnMap $cMap

See also

DBAdapter::bindValue()