JDatabaseSQLSrv
From Joomla! Documentation
JDatabaseSQLSrv is an concrete database handler class for Microsoft Sql Server.
The sqlsrv driver added after Joomla 1.6 alpha 2 and it would be published on the official beta of 1.6. The driver is not full compatible with database general driver (see above the functions), but can work with extensions. Make a lot of tests before put it in production and if you find bugs, please, report them.
Contents |
Availability
Defined in
/libraries/joomla/database/database/sqlsrv.php
Extends
Methods
Properties which do not have specific get or set methods listed here can be retrieved or set using the inherited JObject->get method.
| Method name | Description |
|---|---|
| __construct | Constrctor. Takes database login information, and tries to connecto with the database. |
| __destruct | Destructor. Makes sure database connection is closed at the end of script. |
| connected | Determines if the connection to the server is active. The driver doesn't support this function (?). |
| explain | Diagnostic function. |
| getAffectedRows | Get the number of rows affected by the most recent query. |
| getCollation | Get the database collation. The driver doesn't support this function (?). |
| getEscaped | Get a database escaped string. |
| getNumRows | Get the number of rows returned by the most recent query. |
| getTableCreate | Shows the CREATE TABLE statement that creates the given tables. The driver doesn't support this function (?). |
| getTableFields | Retrieves information about the given tables. |
| getTableList | Lists tables in a database. |
| getVersion | Get the version of the database connector. |
| hasUTF | Determines UTF support. The driver doesn't support this function (?). |
| insertid | Gets the ID generated from the previous INSERT operation. |
| insertObject | Inserts a row into a table based on an objects properties. |
| loadAssoc | Fetch a result row as an associative array. |
| loadAssocList | Loads an associative list of database rows. |
| loadObject | Loads the first row of a query into an object. |
| loadObjectList | Loads a list of database objects. |
| loadResult | Loads the first field of the first row returned by the query. |
| loadResultArray | Loads an array of single field results into an array. |
| loadRow | Loads the first row returned by the query. |
| loadRowList | Loads a list of database rows (numeric column indexing). |
| query | Execute the query. |
| queryBatch | Execute a batch query. |
| select | Select a database for use |
| setUTF | Custom settings for UTF support. The driver doesn't support this function (?). |
| test | Tests to see if the connector is available. |
| updateObject | Updates an object in the database. |
Importing
jimport( 'joomla.database.sqlsrv' );
