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 38
public string
toUpperCase(string $in)
This method is used to ignore case.
in DBMSSQL at line 49
public string
ignoreCase(string $in)
This method is used to ignore case.
in DBMSSQL at line 62
public string
concatString(string $s1, string $s2)
Returns SQL which concatenates the second string to the first.
in DBMSSQL at line 76
public string
subString(string $s, integer $pos, integer $len)
Returns SQL which extracts a substring.
in DBMSSQL at line 87
public string
strLength(string $s)
Returns SQL which calculates the length (in chars) of a string.
in DBMSSQL at line 98
public string
quoteIdentifier(string $text)
in DBMSSQL at line 109
public string
quoteIdentifierTable(string $table)
in DBMSSQL at line 121
public string
random(string $seed = null)
in DBMSSQL at line 144
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