JDatabaseQuerySQLSrv: Difference between revisions
From Joomla! Documentation
Updated to r1448:247ba8d88526 |
m preparing for archive only |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
=={{JVer|11.1}} JDatabaseQuerySQLSrv== | =={{JVer|11.1}} JDatabaseQuerySQLSrv== | ||
===Description=== | ===Description=== | ||
===Methods=== | ===Methods=== | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
| Line 14: | Line 12: | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::auto_increment | |[[API17:JDatabaseQuerySQLSrv::auto_increment|auto_increment]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::castToChar | |[[API17:JDatabaseQuerySQLSrv::castToChar|castToChar]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::charLength | |[[API17:JDatabaseQuerySQLSrv::charLength|charLength]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::concat | |[[API17:JDatabaseQuerySQLSrv::concat|concat]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::delete | |[[API17:JDatabaseQuerySQLSrv::delete|delete]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::dropIfExists | |[[API17:JDatabaseQuerySQLSrv::dropIfExists|dropIfExists]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::fields | |[[API17:JDatabaseQuerySQLSrv::fields|fields]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::from | |[[API17:JDatabaseQuerySQLSrv::from|from]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::group | |[[API17:JDatabaseQuerySQLSrv::group|group]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::having | |[[API17:JDatabaseQuerySQLSrv::having|having]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::innerJoin | |[[API17:JDatabaseQuerySQLSrv::innerJoin|innerJoin]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::insert | |[[API17:JDatabaseQuerySQLSrv::insert|insert]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::insertInto | |[[API17:JDatabaseQuerySQLSrv::insertInto|insertInto]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::join | |[[API17:JDatabaseQuerySQLSrv::join|join]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::leftJoin | |[[API17:JDatabaseQuerySQLSrv::leftJoin|leftJoin]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::length | |[[API17:JDatabaseQuerySQLSrv::length|length]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::lock | |[[API17:JDatabaseQuerySQLSrv::lock|lock]] | ||
|Method to lock the database table for writing. | |Method to lock the database table for writing. | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::now | |[[API17:JDatabaseQuerySQLSrv::now|now]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::order | |[[API17:JDatabaseQuerySQLSrv::order|order]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::outerJoin | |[[API17:JDatabaseQuerySQLSrv::outerJoin|outerJoin]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::renameTable | |[[API17:JDatabaseQuerySQLSrv::renameTable|renameTable]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::rightJoin | |[[API17:JDatabaseQuerySQLSrv::rightJoin|rightJoin]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::select | |[[API17:JDatabaseQuerySQLSrv::select|select]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::set | |[[API17:JDatabaseQuerySQLSrv::set|set]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::showTables | |[[API17:JDatabaseQuerySQLSrv::showTables|showTables]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::unlock | |[[API17:JDatabaseQuerySQLSrv::unlock|unlock]] | ||
|Method to unlock the database table for writing. | |Method to unlock the database table for writing. | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::update | |[[API17:JDatabaseQuerySQLSrv::update|update]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::values | |[[API17:JDatabaseQuerySQLSrv::values|values]] | ||
| | | | ||
|- | |- | ||
|public | |public | ||
|[[JDatabaseQuerySQLSrv::where | |[[API17:JDatabaseQuerySQLSrv::where|where]] | ||
| | | | ||
|- | |- | ||
|} | |} | ||
* '''Defined in''' libraries/joomla/database/database/sqlsrvquery.php | * '''Defined in''' libraries/joomla/database/database/sqlsrvquery.php | ||
* '''Extends''' [[JDatabaseQuery | * '''Extends''' [[API17:JDatabaseQuery|JDatabaseQuery]] | ||
===Importing=== | ===Importing=== | ||
<source lang="php">jimport( 'joomla.database.database.sqlsrvquery' );</source> | <source lang="php">jimport( 'joomla.database.database.sqlsrvquery' );</source> | ||
===See also=== | ===See also=== | ||
* {{JVer|11.1}} '''JDatabaseQuerySQLSrv source code''' on [[jplatform:database/database/sqlsrvquery.php|BitBucket]] | * {{JVer|11.1}} '''JDatabaseQuerySQLSrv source code''' on [[jplatform:database/database/sqlsrvquery.php|BitBucket]] | ||
* {{JVer|11.1}} Subpackage [[Subpackage Database | * {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]] | ||
* [[JDatabaseQuerySQLSrv|Other versions of JDatabaseQuerySQLSrv]] | * [[API17:JDatabaseQuerySQLSrv|Other versions of JDatabaseQuerySQLSrv]] | ||
===User contributed notes=== | ===User contributed notes=== | ||
=== Code Examples === | |||
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=JDatabaseQuerySQLSrv | category=JDatabaseQuerySQLSrv | ||
namespace=CodeExample | |||
category=ClassExample | category=ClassExample | ||
include=* | include=* | ||
| Line 153: | Line 149: | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
<noinclude> | <noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude> | ||
Latest revision as of 02:47, 25 March 2017
JDatabaseQuerySQLSrv
Description
Methods
| Visibility | Method name | Description |
|---|---|---|
| public | auto_increment | |
| public | castToChar | |
| public | charLength | |
| public | concat | |
| public | delete | |
| public | dropIfExists | |
| public | fields | |
| public | from | |
| public | group | |
| public | having | |
| public | innerJoin | |
| public | insert | |
| public | insertInto | |
| public | join | |
| public | leftJoin | |
| public | length | |
| public | lock | Method to lock the database table for writing. |
| public | now | |
| public | order | |
| public | outerJoin | |
| public | renameTable | |
| public | rightJoin | |
| public | select | |
| public | set | |
| public | showTables | |
| public | unlock | Method to unlock the database table for writing. |
| public | update | |
| public | values | |
| public | where |
- Defined in libraries/joomla/database/database/sqlsrvquery.php
- Extends JDatabaseQuery
Importing
jimport( 'joomla.database.database.sqlsrvquery' );
See also
JDatabaseQuerySQLSrv source code on BitBucket
Subpackage Database- Other versions of JDatabaseQuerySQLSrv
User contributed notes
Code Examples