View source for JDatabase::setQuery

=={{JVer|11.1}} JDatabase::setQuery==
===Description===
Sets the SQL statement string for later execution. 



<source lang="php">
public function setQuery (
        $query
        $offset=0
        $limit=0
)
</source>
{| class="wikitable"
|-
!Parameter
!Type
!Default
!Description
|-
|$query
|mixed
|
|The SQL statement to set either as a  object or a string. 
|-
|$offset
|integer
|0
|The affected row offset to set. 
|-
|$limit
|integer
|0
|The maximum affected rows to set.
|-
|}
* '''Returns''' This object to support method chaining.
* '''Defined''' on line 936 of libraries/joomla/database/database.php
* '''Since''' {{JVer|11.1 }}
===See also===
* {{JVer|11.1}} '''JDatabase::setQuery source code''' on [[jplatform:database/database.php#cl-928|BitBucket]]
* {{JVer|11.1}} Class [[API17:JDatabase|JDatabase]]
* {{JVer|11.1}} Subpackage [[API17:Subpackage_Database|Database]]
* [[API17:JDatabase::setQuery|Other versions of JDatabase::setQuery]]


===User contributed notes===
=== Code Examples ===
<dpl>
noresultsheader=\n
category=JDatabase::setQuery
namespace=CodeExample
category=MethodExample
include=*
namespace=CodeExample
format= ,,,
</dpl>
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>