Class for SQL SELECT query manipulation for the Zend_Db_Table component.

• copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
• license: New BSD License

Located in /Db/Table/Select.php (line 46)

Zend_Db_Select
   |
   --Zend_Db_Table_Select

array $_info (line 53)

Table schema for parent Zend_Db_Table.

• access: protected

array $_integrityCheck = true (line 60)

Table integrity override.

• access: protected

Zend_Db_Table_Abstract $_table (line 67)

Table instance that created this select object

• access: protected

Inherited Variables

Inherited from Zend_Db_Select

Zend_Db_Select::$_adapter
Zend_Db_Select::$_bind
Zend_Db_Select::$_joinTypes
Zend_Db_Select::$_parts
Zend_Db_Select::$_partsInit
Zend_Db_Select::$_tableCols
Zend_Db_Select::$_unionTypes

Constructor __construct (line 74)

Class constructor

• access: public

Zend_Db_Table_Select __construct (Zend_Db_Table_Abstract $table, Zend_Db_Table_Abstract $adapter)

• Zend_Db_Table_Abstract $adapter
• Zend_Db_Table_Abstract $table

---

Redefinition of:

Zend_Db_Select::__construct()

Class constructor

assemble (line 190)

Performs a validation on the select query before passing back to the parent class.

Ensures that only columns from the primary Zend_Db_Table are returned in the result.

• return: This object as a SELECT string (or null if a string cannot be produced)
• access: public

string|null assemble ()

---

Redefinition of:

Zend_Db_Select::assemble()

Converts this object to an SQL SELECT string.

from (line 171)

Adds a FROM table and optional columns to the query.

The table name can be expressed

• return: This Zend_Db_Table_Select object.
• access: public

Zend_Db_Table_Select from (array|string|Zend_Db_Expr|Zend_Db_Table_Abstract $name, [array|string|Zend_Db_Expr $cols = self::SQL_WILDCARD], [string $schema = null])

• array|string|Zend_Db_Expr|Zend_Db_Table_Abstract $name: The table name or an
• array|string|Zend_Db_Expr $cols: The columns to select from this table.
• string $schema: The schema name to specify, if any.

---

Redefinition of:

Zend_Db_Select::from()

Adds a FROM table and optional columns to the query.

getTable (line 86)

Return the table that created this select object

• access: public

Zend_Db_Table_Abstract getTable ()

isReadOnly (line 126)

Tests query to determine if expressions or aliases columns exist.

• access: public

boolean isReadOnly ()

setIntegrityCheck (line 115)

Sets the integrity check flag.

Setting this flag to false skips the checks for table joins, allowing 'hybrid' table rows to be created.

• return: This Zend_Db_Select object.
• access: public

Zend_Db_Select setIntegrityCheck ([ $flag = true], Zend_Db_Table_Abstract $adapter)

• Zend_Db_Table_Abstract $adapter
• $flag

setTable (line 97)

Sets the primary table name and retrieves the table schema.

• return: This Zend_Db_Select object.
• access: public

Zend_Db_Select setTable (Zend_Db_Table_Abstract $table, Zend_Db_Table_Abstract $adapter)

• Zend_Db_Table_Abstract $adapter
• Zend_Db_Table_Abstract $table

Inherited Methods

Inherited From Zend_Db_Select

Zend_Db_Select::__construct()
Zend_Db_Select::assemble()
Zend_Db_Select::bind()
Zend_Db_Select::columns()
Zend_Db_Select::distinct()
Zend_Db_Select::forUpdate()
Zend_Db_Select::from()
Zend_Db_Select::getAdapter()
Zend_Db_Select::getBind()
Zend_Db_Select::getPart()
Zend_Db_Select::group()
Zend_Db_Select::having()
Zend_Db_Select::join()
Zend_Db_Select::joinCross()
Zend_Db_Select::joinFull()
Zend_Db_Select::joinInner()
Zend_Db_Select::joinLeft()
Zend_Db_Select::joinNatural()
Zend_Db_Select::joinRight()
Zend_Db_Select::limit()
Zend_Db_Select::limitPage()
Zend_Db_Select::order()
Zend_Db_Select::orHaving()
Zend_Db_Select::orWhere()
Zend_Db_Select::query()
Zend_Db_Select::reset()
Zend_Db_Select::union()
Zend_Db_Select::where()
Zend_Db_Select::_getDummyTable()
Zend_Db_Select::_getQuotedSchema()
Zend_Db_Select::_getQuotedTable()
Zend_Db_Select::_join()
Zend_Db_Select::_joinUsing()
Zend_Db_Select::_renderColumns()
Zend_Db_Select::_renderDistinct()
Zend_Db_Select::_renderForupdate()
Zend_Db_Select::_renderFrom()
Zend_Db_Select::_renderGroup()
Zend_Db_Select::_renderHaving()
Zend_Db_Select::_renderLimitoffset()
Zend_Db_Select::_renderOrder()
Zend_Db_Select::_renderUnion()
Zend_Db_Select::_renderWhere()
Zend_Db_Select::_tableCols()
Zend_Db_Select::_where()
Zend_Db_Select::__call()
Zend_Db_Select::__toString()

Inherited Constants

Inherited from Zend_Db_Select

Zend_Db_Select::COLUMNS
Zend_Db_Select::CROSS_JOIN
Zend_Db_Select::DISTINCT
Zend_Db_Select::FOR_UPDATE
Zend_Db_Select::FROM
Zend_Db_Select::FULL_JOIN
Zend_Db_Select::GROUP
Zend_Db_Select::HAVING
Zend_Db_Select::INNER_JOIN
Zend_Db_Select::LEFT_JOIN
Zend_Db_Select::LIMIT_COUNT
Zend_Db_Select::LIMIT_OFFSET
Zend_Db_Select::NATURAL_JOIN
Zend_Db_Select::ORDER
Zend_Db_Select::RIGHT_JOIN
Zend_Db_Select::SQL_AND
Zend_Db_Select::SQL_AS
Zend_Db_Select::SQL_ASC
Zend_Db_Select::SQL_DESC
Zend_Db_Select::SQL_DISTINCT
Zend_Db_Select::SQL_FOR_UPDATE
Zend_Db_Select::SQL_FROM
Zend_Db_Select::SQL_GROUP_BY
Zend_Db_Select::SQL_HAVING
Zend_Db_Select::SQL_ON
Zend_Db_Select::SQL_OR
Zend_Db_Select::SQL_ORDER_BY
Zend_Db_Select::SQL_SELECT
Zend_Db_Select::SQL_UNION
Zend_Db_Select::SQL_UNION_ALL
Zend_Db_Select::SQL_WHERE
Zend_Db_Select::SQL_WILDCARD
Zend_Db_Select::UNION
Zend_Db_Select::WHERE