Interface DeleteQueryInterface

Description

A DeleteQuery interface provides the tools to build an SQL DELETE query.

  • version: $Id: DeleteQuery.interface.php,v 1.7 2007/09/05 21:38:59 adamfranco Exp $
  • license: GNU General Public License (GPL)
  • copyright: Copyright © 2005, Middlebury College

Located in /harmoni/core/DBHandler/DeleteQuery.interface.php (line 25)

Query
   |
   --DeleteQueryInterface
Method Summary
void addWhere (string $condition, [integer $logicalOperation = _AND])
void setTable (string $table)
void setWhere (string $condition)
Methods
addWhere (line 60)

Adds a new condition in the WHERE clause.

The query will execute only on rows that fulfil the condition. If this method is never called, then the WHERE clause will not be included.

  • access: public
void addWhere (string $condition, [integer $logicalOperation = _AND])
  • string $condition: condition The WHERE clause condition to add.
  • integer $logicalOperation: logicalOperation The logical operation to use to connect this WHERE condition with the previous WHERE conditions. Allowed values:
    1. _AND
    and
    1. _OR
    .
setTable (line 34)

Sets the table to delete from.

  • access: public
void setTable (string $table)
  • string $table: The table to delete from.
setWhere (line 45)

*Deprecated* Specifies the condition in the WHERE clause.

The query will execute only on rows that fulfil the condition. If this method is never called, then the WHERE clause will not be included.

  • deprecated: July 09, 2003 - Use addWhere() instead.
  • access: public
void setWhere (string $condition)
  • string $condition: The WHERE clause condition.

Inherited Methods

Inherited From Query

Query::getType()
Query::reset()

Documentation generated on Wed, 19 Sep 2007 10:22:42 -0400 by phpDocumentor 1.3.0RC3