MDB_mssql (Constructor) [line 92]
autoCommit [line 210]
mixed autoCommit(
boolean
$auto_commit)
|
|
Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.
Overrides
MDB_Common::autoCommit() (Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.)
Parameters:
commit [line 248]
Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
Overrides
MDB_Common::commit() (Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.)
connect [line 311]
convertResult [line 635]
mixed convertResult(
mixed
$value, int
$type)
|
|
convert a value to a RDBMS indepdenant MDB type
Overrides
MDB_Common::convertResult() (convert a value to a RDBMS indepdenant MDB type)
Parameters:
endOfResult [line 553]
mixed endOfResult(
resource
$result)
|
|
check if the end of the result set has been reached
Overrides
MDB_Common::endOfResult() (check if the end of the result set has been reached)
Parameters:
errorNative [line 135]
Get the native error code of the last error (if any) that occured on the current connection.
Overrides
MDB_Common::errorNative() (returns an errormessage, provides by the database)
fetch [line 575]
mixed fetch(
resource
$result, int
$row, int
$field)
|
|
fetch value from a result set
Overrides
MDB_Common::fetch() (fetch value from a result set)
Parameters:
fetchBlob [line 619]
mixed fetchBlob(
resource
$result, int
$row, int
$field)
|
|
fetch a blob value from a result set
Overrides
MDB_Common::fetchBlob() (fetch a blob value from a result set)
Parameters:
fetchClob [line 602]
mixed fetchClob(
resource
$result, int
$row, int
$field)
|
|
fetch a clob value from a result set
Overrides
MDB_Common::fetchClob() (fetch a clob value from a result set)
Parameters:
fetchInto [line 1225]
int fetchInto(
resource
$result, [int
$fetchmode = MDB_FETCHMODE_DEFAULT], [int
$rownum = NULL])
|
|
Fetch a row and insert the data into an existing array.
Overrides
MDB_Common::fetchInto() (Fetch a row and return data in an array.)
Parameters:
freeBlobValue [line 1110]
MDB_OK freeBlobValue(
resource
$prepared_query, string
$blob)
|
|
free a binary large object
Overrides
MDB_Common::freeBlobValue() (free a binary large object)
Parameters:
freeClobValue [line 1066]
MDB_OK freeClobValue(
resource
$prepared_query, string
$clob)
|
|
free a character large object
Overrides
MDB_Common::freeClobValue() (free a character large object)
Parameters:
freeResult [line 688]
boolean freeResult(
$result
$result)
|
|
Free the internal resources associated with $result.
Overrides
MDB_Common::freeResult() (Free the internal resources associated with $result.)
Parameters:
getBlobDeclaration [line 843]
string getBlobDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getBlobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.)
Parameters:
getBlobValue [line 1086]
string getBlobValue(
resource
$prepared_query, $parameter
$parameter, $blob
$blob)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getBlobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getBooleanDeclaration [line 880]
string getBooleanDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getBooleanDeclaration() (Obtain DBMS specific SQL code portion needed to declare a boolean type field to be used in statements like CREATE TABLE.)
Parameters:
getBooleanValue [line 1128]
string getBooleanValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getBooleanValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getClobDeclaration [line 802]
string getClobDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getClobDeclaration() (Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.)
Parameters:
getClobValue [line 1042]
string getClobValue(
resource
$prepared_query, $parameter
$parameter, $clob
$clob)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getClobValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getColumnNames [line 502]
mixed getColumnNames(
resource
$result)
|
|
Retrieve the names of columns returned by the DBMS in a query result.
Overrides
MDB_Common::getColumnNames() (Retrieve the names of columns returned by the DBMS in a query result.)
Parameters:
getDateDeclaration [line 908]
string getDateDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an date type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getDateDeclaration() (Obtain DBMS specific SQL code portion needed to declare a date type field to be used in statements like CREATE TABLE.)
Parameters:
getDecimalDeclaration [line 1023]
string getDecimalDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an decimal type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getDecimalDeclaration() (Obtain DBMS specific SQL code portion needed to declare a decimal type field to be used in statements like CREATE TABLE.)
Parameters:
getDecimalValue [line 1162]
string getDecimalValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getDecimalValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getFloatDeclaration [line 994]
string getFloatDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an float type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getFloatDeclaration() (Obtain DBMS specific SQL code portion needed to declare a float type field to be used in statements like CREATE TABLE.)
Parameters:
getFloatValue [line 1145]
string getFloatValue(
string
$value)
|
|
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Overrides
MDB_Common::getFloatValue() (Convert a text value into a DBMS specific format that is suitable to compose query statements.)
Parameters:
getIntegerDeclaration [line 735]
string getIntegerDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getIntegerDeclaration() (Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.)
Parameters:
getTextDeclaration [line 771]
string getTextDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTextDeclaration() (Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.)
Parameters:
getTimeDeclaration [line 965]
string getTimeDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an time type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTimeDeclaration() (Obtain DBMS specific SQL code portion needed to declare a time field to be used in statements like CREATE TABLE.)
Parameters:
getTimestampDeclaration [line 937]
string getTimestampDeclaration(
string
$name, string
$field)
|
|
Obtain DBMS specific SQL code portion needed to declare an timestamp type field to be used in statements like CREATE TABLE.
Overrides
MDB_Common::getTimestampDeclaration() (Obtain DBMS specific SQL code portion needed to declare a timestamp field to be used in statements like CREATE TABLE.)
Parameters:
mssqlRaiseError [line 161]
object a mssqlRaiseError(
[integer
$errno = NULL], [string
$message = NULL])
|
|
This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for MDB::raiseError that checks for native error msgs.
Parameters:
nextId [line 1181]
mixed nextId(
string
$seq_name, [boolean
$ondemand = TRUE])
|
|
returns the next free id of a sequence
Overrides
MDB_Common::nextId() (returns the next free id of a sequence)
Parameters:
numCols [line 534]
mixed numCols(
resource
$result)
|
|
Count the number of columns returned by the DBMS in a query result.
Overrides
MDB_Common::numCols() (Count the number of columns returned by the DBMS in a query result.)
Parameters:
numRows [line 667]
mixed numRows(
ressource
$result)
|
|
returns the number of rows in a result object
Overrides
MDB_Common::numRows() (returns the number of rows in a result object)
Parameters:
query [line 426]
mixed query(
string
$query, [mixed
$types = NULL])
|
|
Send a query to the database and return any results
Overrides
MDB_Common::query() (Send a query to the database and return any results)
Parameters:
quoteIdentifier [line 186]
string quoteIdentifier(
string
$str)
|
|
Quote a string so it can be safely used as a table / column name
Quoting style depends on which database driver is being used.
Overrides
MDB_Common::quoteIdentifier() (Quote a string so it can be safely used as a table or column name)
Parameters:
rollback [line 279]
Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
Overrides
MDB_Common::rollback() (Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.)
standaloneQuery [line 393]
void standaloneQuery(
$query)
|
|
Parameters:
tableInfo [line 1277]
array tableInfo(
$result, [int
$mode = NULL], mixed
$resource)
|
|
Returns information about a table or a result set
NOTE: doesn't support table name and flags if called from a db_result
Overrides
MDB_Common::tableInfo() (returns meta data about the result set)
Parameters: