API16:JDatabaseQuery/set

This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

<! removed transcluded page call, red link never existed >

Syntax

set($conditions, $glue=',')

Parameter Name	Default Value	Description
$conditions		A string or array of conditions
$glue	','

Defined in

libraries/joomla/database/databasequery.php

Importing

jimport( 'joomla.database.databasequery' );

Source Body

public function set($conditions, $glue=',')
{
        if (is_null($this->_set)) {
                $glue = strtoupper($glue);
                $this->_set = new JDatabaseQueryElement('SET', $conditions, "\n\t$glue ");
        } else {
                $this->_set->append($conditions);
        }
 
        return $this;
}

<! removed transcluded page call, red link never existed >

Examples

<CodeExamplesForm />

No Title

Example:

$query  = $db->getQuery(true);
$query->insert('#__tableName');
 
$query->set('id=4');
 
$db->setQuery( $query );
$result = $db->loadResult();

Unhindered 16:28, 18 August 2010 (CDT) Edit comment

$query  = $db->getQuery(true);
$query->insert('#__table_name');
'''$query->set('id=2');
$query->set('something_else=4');'''
$db->setQuery( $query );
$result = $db->loadResult();