API17

Difference between revisions of "JDatabaseQuerySQLSrv"

From Joomla! Documentation

m (→‎User contributed notes: moving preparation)
m (preparing for archive only)
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
=={{JVer|11.1}} JDatabaseQuerySQLSrv==
 
=={{JVer|11.1}} JDatabaseQuerySQLSrv==
 
===Description===
 
===Description===
{{Description:JDatabaseQuerySQLSrv}}
+
 
<span class="editsection" style="font-size:76%;">
+
 
<nowiki>[</nowiki>[[Description:JDatabaseQuerySQLSrv|Edit Descripton]]<nowiki>]</nowiki>
 
</span>
 
 
===Methods===
 
===Methods===
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
Line 14: Line 12:
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::auto_increment/11.1|auto_increment]]
+
|[[API17:JDatabaseQuerySQLSrv::auto_increment|auto_increment]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::castToChar/11.1|castToChar]]
+
|[[API17:JDatabaseQuerySQLSrv::castToChar|castToChar]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::charLength/11.1|charLength]]
+
|[[API17:JDatabaseQuerySQLSrv::charLength|charLength]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::concat/11.1|concat]]
+
|[[API17:JDatabaseQuerySQLSrv::concat|concat]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::delete/11.1|delete]]
+
|[[API17:JDatabaseQuerySQLSrv::delete|delete]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::dropIfExists/11.1|dropIfExists]]
+
|[[API17:JDatabaseQuerySQLSrv::dropIfExists|dropIfExists]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::fields/11.1|fields]]
+
|[[API17:JDatabaseQuerySQLSrv::fields|fields]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::from/11.1|from]]
+
|[[API17:JDatabaseQuerySQLSrv::from|from]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::group/11.1|group]]
+
|[[API17:JDatabaseQuerySQLSrv::group|group]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::having/11.1|having]]
+
|[[API17:JDatabaseQuerySQLSrv::having|having]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::innerJoin/11.1|innerJoin]]
+
|[[API17:JDatabaseQuerySQLSrv::innerJoin|innerJoin]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::insert/11.1|insert]]
+
|[[API17:JDatabaseQuerySQLSrv::insert|insert]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::insertInto/11.1|insertInto]]
+
|[[API17:JDatabaseQuerySQLSrv::insertInto|insertInto]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::join/11.1|join]]
+
|[[API17:JDatabaseQuerySQLSrv::join|join]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::leftJoin/11.1|leftJoin]]
+
|[[API17:JDatabaseQuerySQLSrv::leftJoin|leftJoin]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::length/11.1|length]]
+
|[[API17:JDatabaseQuerySQLSrv::length|length]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::lock/11.1|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/11.1|now]]
+
|[[API17:JDatabaseQuerySQLSrv::now|now]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::order/11.1|order]]
+
|[[API17:JDatabaseQuerySQLSrv::order|order]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::outerJoin/11.1|outerJoin]]
+
|[[API17:JDatabaseQuerySQLSrv::outerJoin|outerJoin]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::renameTable/11.1|renameTable]]
+
|[[API17:JDatabaseQuerySQLSrv::renameTable|renameTable]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::rightJoin/11.1|rightJoin]]
+
|[[API17:JDatabaseQuerySQLSrv::rightJoin|rightJoin]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::select/11.1|select]]
+
|[[API17:JDatabaseQuerySQLSrv::select|select]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::set/11.1|set]]
+
|[[API17:JDatabaseQuerySQLSrv::set|set]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::showTables/11.1|showTables]]
+
|[[API17:JDatabaseQuerySQLSrv::showTables|showTables]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::unlock/11.1|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/11.1|update]]
+
|[[API17:JDatabaseQuerySQLSrv::update|update]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::values/11.1|values]]
+
|[[API17:JDatabaseQuerySQLSrv::values|values]]
 
|
 
|
 
|-
 
|-
 
|public  
 
|public  
|[[JDatabaseQuerySQLSrv::where/11.1|where]]
+
|[[API17:JDatabaseQuerySQLSrv::where|where]]
 
|
 
|
 
|-
 
|-
 
|}
 
|}
 
* '''Defined in''' libraries/joomla/database/database/sqlsrvquery.php
 
* '''Defined in''' libraries/joomla/database/database/sqlsrvquery.php
* '''Extends''' [[JDatabaseQuery/11.1|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/11.1|Database]]
+
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
* [[JDatabaseQuerySQLSrv|Other versions of JDatabaseQuerySQLSrv]]
+
* [[API17:JDatabaseQuerySQLSrv|Other versions of JDatabaseQuerySQLSrv]]
{{SeeAlso:JDatabaseQuerySQLSrv}}
+
 
<span class="editsection" style="font-size:76%;">
+
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuerySQLSrv|Edit See Also]]<nowiki>]</nowiki>
 
</span>
 
 
===User contributed notes===
 
===User contributed notes===
<CodeExamplesForm />
+
=== Code Examples ===
 
<dpl>
 
<dpl>
 
noresultsheader=\n
 
noresultsheader=\n
 
category=JDatabaseQuerySQLSrv
 
category=JDatabaseQuerySQLSrv
category=CodeExample
+
namespace=CodeExample
 
category=ClassExample
 
category=ClassExample
 
include=*
 
include=*

Latest revision as of 21:47, 24 March 2017

The "API17" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Joomla 11.1 JDatabaseQuerySQLSrv[edit]

Description[edit]

Methods[edit]

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[edit]

jimport( 'joomla.database.database.sqlsrvquery' );

See also[edit]


User contributed notes[edit]

Code Examples[edit]