Output zend-framework Zend_Db_Table select () generated request

Question

I want to output a query generated by the select () Zend_Db_Table statement for testing, but I do not know how to do this.

Answer 1

It is really very simple. The select object implements the toString method.

$select = $table->select()->.... echo $select; //prints SQL 

or

 $sql = $select->__toString(); 

Answer 2

or translate it into a string and then use:

 (string)$table->select();