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, string $charset)

string toUpperCase(string $in)

This method is used to ignore case.

 from DBMSSQL
string ignoreCase(string $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, integer $pos, integer $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
string quoteIdentifier(string $text)

from DBMSSQL
string quoteIdentifierTable(string $table)

from DBMSSQL
string random(string $seed = null)

from DBMSSQL
void applyLimit(string $sql, integer $offset, integer $limit)

Simulated Limit/Offset

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

initConnection(PDO $con, array $settings)

boolean bindValue(PDOStatement $stmt, string $parameter, mixed $value, ColumnMap $cMap, null|integer $position = null)

Details

at line 42
public setCharset(PDO $con, string $charset)

Parameters

PDO $con A $PDO PDO connection instance.
string $charset The $string charset encoding.

Exceptions

PropelException

See also

parent::setCharset()

in DBMSSQL at line 39
public string toUpperCase(string $in)

This method is used to ignore case.

Parameters

string $in The string to transform to upper case.

Return Value

string The upper case string.

in DBMSSQL at line 51
public string ignoreCase(string $in)

This method is used to ignore case.

Parameters

string $in The string whose case to ignore.

Return Value

string The string in a case that can be ignored.

in DBMSSQL at line 64
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 78
public string subString(string $s, integer $pos, integer $len)

Returns SQL which extracts a substring.

Parameters

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

Return Value

string

in DBMSSQL at line 90
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 102
public string quoteIdentifier(string $text)

Parameters

string $text The identifier to quote.

Return Value

string The quoted identifier.

See also

DBAdapter::quoteIdentifier()

in DBMSSQL at line 114
public string quoteIdentifierTable(string $table)

Parameters

string $table The table name to quo

Return Value

string The quoted table name

See also

DBAdapter::quoteIdentifierTable()

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

Parameters

string $seed (optional) seed value for databases that support this

Return Value

string

See also

DBAdapter::random()

in DBMSSQL at line 150
public void applyLimit(string $sql, integer $offset, integer $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

string $sql
integer $offset
integer $limit

Return Value

void

Exceptions

PropelException
Exception

See also

DBAdapter::applyLimit()

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

Parameters

string $sql The sql statement
array $params array('column' => ..., 'table' => ..., 'value' => ...)
Criteria $values
DatabaseMap $dbMap

See also

parent::cleanupSQL()

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

Parameters

PDO $con
array $settings

See also

parent::initConnection()

at line 95
public boolean bindValue(PDOStatement $stmt, string $parameter, mixed $value, ColumnMap $cMap, null|integer $position = null)

Parameters

PDOStatement $stmt
string $parameter
mixed $value
ColumnMap $cMap
null|integer $position

Return Value

boolean

See also

DBAdapter::bindValue()