Class Zend_Db_Table_Select

Class for SQL SELECT query manipulation for the Zend_Db_Table component.

Zend_Db_Table_Select

Package: Zend\Db\Table
Category: Zend
Copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License
Located at Zend/Db/Table/Select.php

Methods summary
`public`	# `__construct( Zend_Db_Table_Abstract $table )` Class constructor Class constructor Parameters `$table` `Zend_Db_Table_Abstract` $adapter
`public Zend_Db_Table_Abstract`	# `getTable( )` Return the table that created this select object Return the table that created this select object Returns `Zend_Db_Table_Abstract`
`public Zend_Db_Select`	# `setTable( Zend_Db_Table_Abstract $table )` Sets the primary table name and retrieves the table schema. Sets the primary table name and retrieves the table schema. Parameters `$table` `Zend_Db_Table_Abstract` $adapter Returns `Zend_Db_Select` This Zend_Db_Select object.
`public Zend_Db_Select`	# `setIntegrityCheck( Zend_Db_Table_Abstract $flag = true )` Sets the integrity check flag. Sets the integrity check flag. Setting this flag to false skips the checks for table joins, allowing 'hybrid' table rows to be created. Parameters `$flag` `Zend_Db_Table_Abstract` $adapter Returns `Zend_Db_Select` This Zend_Db_Select object.
`public boolean`	# `isReadOnly( )` Tests query to determine if expressions or aliases columns exist. Tests query to determine if expressions or aliases columns exist. Returns `boolean`
`public Zend_Db_Table_Select`	# `from( array\|string\|Zend_Db_Expr\|Zend_Db_Table_Abstract $name, array\|string\|Zend_Db_Expr $cols = Zend_Db_Select::SQL_WILDCARD, string $schema = null )` Adds a FROM table and optional columns to the query. Adds a FROM table and optional columns to the query. The table name can be expressed Parameters `$name` `array\|string\|Zend_Db_Expr\|Zend_Db_Table_Abstract` The table name or an associative array relating table name to correlation name. `$cols` `array\|string\|Zend_Db_Expr` The columns to select from this table. `$schema` `string` The schema name to specify, if any. Returns `Zend_Db_Table_Select` This Zend_Db_Table_Select object.
`public string\|null`	# `assemble( )` 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. 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. Returns `string\|null` This object as a SELECT string (or null if a string cannot be produced)

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

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

Properties summary
`protected array`	`$_info`		# Table schema for parent Zend_Db_Table. Table schema for parent Zend_Db_Table.
`protected array`	`$_integrityCheck`	`true`	# Table integrity override. Table integrity override.
`protected Zend_Db_Table_Abstract`	`$_table`		# Table instance that created this select object Table instance that created this select object

Properties inherited from Zend_Db_Select
`$_adapter, $_bind, $_joinTypes, $_parts, $_partsInit, $_tableCols, $_unionTypes`

Packages

Classes

Exceptions

Class Zend_Db_Table_Select

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Parameters

Returns

Returns