I also think that the parts must be accessible. Zend_Db_Select should offer some setter or getter methods to change i.e. the columns. We want to create a DB pager class with Zend_Db_Select. In the pager class the limitPage Method is very usefull, but we need to reset some parts.

The solution for ZF-1 will provide a large portion of the solution to this problem. In order to properly submit ZF "where" clauses and other data collected programmatically through an OO interface to a DB driver in a format suitable for prepared queries (if supported by that driver), all parts of the SQL query need to be kept separated, instead of combined into a string. If the parts collected via the programmatic interface are stored individually, the parts can then be quoted correctly (e.g. quoting for column names is not always the same for other identifiers, depending on the DB). Additional API methods could then be added to get and set the parts of the query.

Creating a programmatic interface that offers the above features without becoming more difficult than using raw SQL with PHP's PDO object will not be a simple task. Contact the ZF DB Project Team, if you would like to help!

http://framework.zend.com/wiki/display/…

Changing fix version to 0.8.0.

Recategorize in Zend_Db_Select component.

I guess the following would be more ideal as it resets a specific part or the entire parts array optionally:

[code] /** * Resets a part of the SELECT statement to null, so you can set it again without creating a new Select object * * @param string $part The part to reset (e.g. 'where', 'limit', etc.) * @return true on success, otherwise false */

public function reset( $part = '' ) 
{
    // find part in private $_parts array
    if( ! $part )

        // No part specified; reset entire parts array
        $this->_parts = array();

    } elseif ( in_array($part, $this->_parts)) {

        // reset specific part
        $this->_parts[$part] = null;

    }
}

Applied the right code tags:

I guess the following would be more ideal as it resets a specific part or the entire parts array optionally:

``` /** * Resets a part of the SELECT statement to null, so you can set it again without creating a new Select object * * @param string $part The part to reset (e.g. 'where', 'limit', etc.) * @return true on success, otherwise false */

public function reset( $part = '' ) 
{
    // find part in private $_parts array
    if( ! $part )

        // No part specified; reset entire parts array
        $this->_parts = array();

    } elseif ( in_array($part, $this->_parts)) {

        // reset specific part
        $this->_parts[$part] = null;

    }
}

Fixed in revision 3320.

New method {{reset()}} clears all parts internal to the Select object. With a parameter, it clears one individual part. For example:

$select->reset('where');

There are also constants defined to make it easier to name the parts. For example:

$select->reset( Zend_Db_Select::WHERE );

Change summary wording.