|
|
| Line 1: |
Line 1: |
| − | '''JDatabaseSQLSrv''' is an concrete database handler class for [http://www.microsoft.com/sql/default.mspx Microsoft Sql Server].
| + | This class is available in the following Joomla versions:- |
| − | | + | <splist showpath=notparent /> |
| − | The sqlsrv driver added after to branch on Joomla 1.6 alpha 2 <del>and it would be published on the official beta of 1.6<del> (don't sure about that, so, take it from [http://svn.joomlacode.org/svn/joomla/development/branches/database/libraries/joomla/database/database/ the branch]).
| + | <noinclude>[[Category:Platform]][[Category:JDatabaseSQLSrv]]</noinclude> |
| − | The driver is not full compatible with [[JDatabase|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.
| + | |
| − | | + | |
| − | ===Availability===
| + | |
| − | {{JVer|1.6}}
| + | |
| − | | + | |
| − | ===Defined in===
| + | |
| − | /libraries/joomla/database/database/sqlsrv.php
| + | |
| − | | + | |
| − | ===Extends===
| + | |
| − | * [[JObject]]
| + | |
| − | * [[JDatabase]]
| + | |
| − | | + | |
| − | ===Methods===
| + | |
| − | Properties which do not have specific get or set methods listed here can be retrieved or set using the inherited [[JObject/get|JObject->get]] method.
| + | |
| − | {| class="wikitable"
| + | |
| − | |-
| + | |
| − | !Method name
| + | |
| − | !Description
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/__construct|__construct]]
| + | |
| − | |Constrctor. Takes database login information, and tries to connecto with the database.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/__destruct|__destruct]]
| + | |
| − | |Destructor. Makes sure database connection is closed at the end of script.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/connected|connected]]
| + | |
| − | |Determines if the connection to the server is active. The driver doesn't support this function (?).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/explain|explain]]
| + | |
| − | |Diagnostic function.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getAffectedRows|getAffectedRows]]
| + | |
| − | |Get the number of rows affected by the most recent query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getCollation|getCollation]]
| + | |
| − | |Get the database collation. The driver doesn't support this function (?).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getEscaped|getEscaped]]
| + | |
| − | |Get a database escaped string.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getNumRows|getNumRows]]
| + | |
| − | |Get the number of rows returned by the most recent query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getTableCreate|getTableCreate]]
| + | |
| − | |Shows the CREATE TABLE statement that creates the given tables. The driver doesn't support this function (?).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getTableFields|getTableFields]]
| + | |
| − | |Retrieves information about the given tables.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getTableList|getTableList]]
| + | |
| − | |Lists tables in a database.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/getVersion|getVersion]]
| + | |
| − | |Get the version of the database connector.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/hasUTF|hasUTF]]
| + | |
| − | |Determines UTF support. The driver doesn't support this function (?).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/insertid|insertid]]
| + | |
| − | |Gets the ID generated from the previous INSERT operation.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/insertObject|insertObject]]
| + | |
| − | |Inserts a row into a table based on an objects properties.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadAssoc|loadAssoc]]
| + | |
| − | |Fetch a result row as an associative array.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadAssocList|loadAssocList]]
| + | |
| − | |Loads an associative list of database rows.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadObject|loadObject]]
| + | |
| − | |Loads the first row of a query into an object.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadObjectList|loadObjectList]]
| + | |
| − | |Loads a list of database objects.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadResult|loadResult]]
| + | |
| − | |Loads the first field of the first row returned by the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadResultArray|loadResultArray]]
| + | |
| − | |Loads an array of single field results into an array.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadRow|loadRow]]
| + | |
| − | |Loads the first row returned by the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/loadRowList|loadRowList]]
| + | |
| − | |Loads a list of database rows (numeric column indexing).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/query|query]]
| + | |
| − | |Execute the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/queryBatch|queryBatch]]
| + | |
| − | |Execute a batch query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/select|select]]
| + | |
| − | |Select a database for use
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/setUTF|setUTF]]
| + | |
| − | |Custom settings for UTF support. The driver doesn't support this function (?).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/test|test]]
| + | |
| − | |Tests to see if the connector is available.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseSQLSrv/updateObject|updateObject]]
| + | |
| − | |Updates an object in the database.
| + | |
| − | |}
| + | |
| − | | + | |
| − | ===Importing===
| + | |
| − | <source lang="php">jimport( 'joomla.database.sqlsrv' );</source> | + | |
| − | | + | |
| − | ===See also===
| + | |
| − | * [[How to use the database classes in your script]]
| + | |
| − | * [[JDatabaseMySQL]]
| + | |
| − | * [[JDatabaseMySQLi]]
| + | |
| − | <noinclude>[[Category:Development]][[Category:Framework]][[Category:JDatabase]]</noinclude> | + | |
