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)
in DBMSSQL at line 39
public string
toUpperCase(string $in)
This method is used to ignore case.
in DBMSSQL at line 51
public string
ignoreCase(string $in)
This method is used to ignore case.
in DBMSSQL at line 64
public string
concatString(string $s1, string $s2)
Returns SQL which concatenates the second string to the first.
in DBMSSQL at line 78
public string
subString(string $s, integer $pos, integer $len)
Returns SQL which extracts a substring.
in DBMSSQL at line 90
public string
strLength(string $s)
Returns SQL which calculates the length (in chars) of a string.
in DBMSSQL at line 102
public string
quoteIdentifier(string $text)
in DBMSSQL at line 114
public string
quoteIdentifierTable(string $table)
in DBMSSQL at line 127
public string
random(string $seed = null)
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
at line 64
public
cleanupSQL(string $sql, array $params, Criteria $values, DatabaseMap $dbMap)
at line 26
public
initConnection(PDO $con, array $settings)
at line 95
public boolean
bindValue(PDOStatement $stmt, string $parameter, mixed $value, ColumnMap $cMap, null|integer $position = null)