static array $_joinTypes = array(
self::INNER_JOIN,
self::LEFT_JOIN,
self::RIGHT_JOIN,
self::FULL_JOIN,
self::CROSS_JOIN,
self::NATURAL_JOIN,
) (line 124)

Specify legal join types.

• access: protected

static array $_unionTypes = array(
self::SQL_UNION,
self::SQL_UNION_ALL
) (line 138)

Specify legal union types.

• access: protected

array $_bind = array() (line 89)

Bind variables for query

• access: protected

array $_tableCols = array() (line 156)

Tracks which columns are being select from each table and join.

• access: protected

bind (line 185)

Set bind variables

• access: public

• mixed $bind

distinct (line 198)

Makes the query SELECT DISTINCT.

• return: This Zend_Db_Select object.
• access: public

• bool $flag: Whether or not the SELECT is DISTINCT (default true).

from (line 228)

Adds a FROM table and optional columns to the query.

The first parameter $name can be a simple string, in which case the correlation name is generated automatically. If you want to specify the correlation name, the first parameter must be an associative array in which the key is the physical table name, and the value is the correlation name. For example, array('table' => 'alias'). The correlation name is prepended to all columns fetched for this table.

The second parameter can be a single string or Zend_Db_Expr object, or else an array of strings or Zend_Db_Expr objects.

The first parameter can be null or an empty string, in which case no correlation name is generated or prepended to the columns named in the second parameter.

• return: This Zend_Db_Select object.
• access: public

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

• Zend_Db_Table_Select::from() : Adds a FROM table and optional columns to the query.

getBind (line 174)

Get bind variables

• access: public

group (line 505)

Adds grouping to the query.

• return: This Zend_Db_Select object.
• access: public

• array|string $spec: The column(s) to group by.

join (line 313)

Adds a JOIN table and columns to the query.

The $name and $cols parameters follow the same logic as described in the from() method.

• return: This Zend_Db_Select object.
• access: public

• array|string|Zend_Db_Expr $name: The table name.
• string $cond: Join on this condition.
• array|string $cols: The columns to select from the joined table.
• string $schema: The database name to specify, if any.

joinFull (line 399)

Add a FULL OUTER JOIN table and colums to the query.

A full outer join is like combining a left outer join and a right outer join. All rows from both tables are included, paired with each other on the same row of the result set if they satisfy the join condition, and otherwise paired with NULLs in place of columns from the other table.

The $name and $cols parameters follow the same logic as described in the from() method.

• return: This Zend_Db_Select object.
• access: public

• array|string|Zend_Db_Expr $name: The table name.
• string $cond: Join on this condition.
• array|string $cols: The columns to select from the joined table.
• string $schema: The database name to specify, if any.

joinLeft (line 355)

Add a LEFT OUTER JOIN table and colums to the query

All rows from the left operand table are included, matching rows from the right operand table included, and the columns from the right operand table are filled with NULLs if no row exists matching the left table.

The $name and $cols parameters follow the same logic as described in the from() method.

• return: This Zend_Db_Select object.
• access: public

• array|string|Zend_Db_Expr $name: The table name.
• string $cond: Join on this condition.
• array|string $cols: The columns to select from the joined table.
• string $schema: The database name to specify, if any.

joinRight (line 377)

Add a RIGHT OUTER JOIN table and colums to the query.

Right outer join is the complement of left outer join. All rows from the right operand table are included, matching rows from the left operand table included, and the columns from the left operand table are filled with NULLs if no row exists matching the right table.

The $name and $cols parameters follow the same logic as described in the from() method.

• return: This Zend_Db_Select object.
• access: public

• array|string|Zend_Db_Expr $name: The table name.
• string $cond: Join on this condition.
• array|string $cols: The columns to select from the joined table.
• string $schema: The database name to specify, if any.

limitPage (line 635)

Sets the limit and count by page number.

• return: This Zend_Db_Select object.
• access: public

• int $page: Limit results to this page number.
• int $rowCount: Use this many rows per page.

orHaving (line 559)

Adds a HAVING condition to the query by OR.

Otherwise identical to orHaving().

• return: This Zend_Db_Select object.
• see: Zend_Db_Select::having()
• access: public

• string $cond: The HAVING condition.
• mixed $val: The value to quote into the condition.

query (line 680)

Executes the current select object and returns the result

• access: public

• integer $fetchMode: OPTIONAL
• mixed $bind: An array of data to bind to the placeholders.

Constructor __construct (line 163)

Class constructor

• access: public

• Zend_Db_Adapter_Abstract $adapter

• Zend_Db_Table_Select::__construct() : Class constructor

where (line 473)

Adds a WHERE condition to the query by AND.

If a value is passed as the second param, it will be quoted and replaced into the condition wherever a question-mark appears. Array values are quoted and comma-separated.

Note that it is more correct to use named bindings in your queries for values other than strings. When you use named bindings, don't forget to pass the values when actually making a query:

• return: This Zend_Db_Select object.
• access: public

• string $cond: The WHERE condition.
• mixed $value: OPTIONAL The value to quote into the condition.
• constant $type: OPTIONAL The type of the given value

_getQuotedSchema (line 1029)

Return a quoted schema name

• access: protected

• string $schema: The schema name OPTIONAL

_join (line 754)

Populate the $_parts 'join' key

Does the dirty work of populating the join key.

The $name and $cols parameters follow the same logic as described in the from() method.

• return: This Zend_Db_Select object
• throws: Zend_Db_Select_Exception
• access: protected

• null|string $type: Type of join; inner, left, and null are currently supported
• array|string|Zend_Db_Expr $name: Table name
• string $cond: Join on this condition
• array|string $cols: The columns to select from the joined table
• string $schema: The database name to specify, if any.

_renderColumns (line 1070)

Render DISTINCT clause

• access: protected

• string $sql: SQL query

_renderForupdate (line 1284)

Render FOR UPDATE clause

• access: protected

• string $sql: SQL query

_renderGroup (line 1191)

Render GROUP clause

• access: protected

• string $sql: SQL query

_renderLimitoffset (line 1254)

Render LIMIT OFFSET clause

• access: protected

• string $sql: SQL query

_renderUnion (line 1151)

Render UNION query

• access: protected

• string $sql: SQL query

_tableCols (line 920)

Adds to the internal table-to-column mapping array.

• access: protected

• string $tbl: The table/join the columns come from.
• array|string $cols: The list of columns; preferably as an array, but possibly as a string containing one column.
• bool|string $afterCorrelationName: True if it should be prepended, a correlation name if it should be inserted
• $correlationName

__call (line 1302)

Turn magic function calls into non-magic function calls for joinUsing syntax

• throws: Zend_Db_Select_Exception If an invalid method is called.
• access: public

• string $method
• array $args: OPTIONAL Zend_Db_Table_Select query modifier