Re: [fw-db] view complete sql statement on error

You can use profiler http://framework.zend.com/manual/en/zend.db.profiler.html, it's handy to print them to firebug when in test env. Or use Scienta ZF Debug Bar. Or simply echo your statement.

Regards,
Saša Stamenković

On Thu, Jul 30, 2009 at 10:49 AM, Ari Awan <ariawan.jp@gmail.com> wrote:

Hi all,

Is there a way to make stack trace to display the whole generated SQL statement when there is an error instead just the first few characters of it?

This is what it currently displays

#3 ... /library/Zend/Db/Adapter/Abstract.php(542):
Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `us...', Array)
#4 ... /library/Zend/Db/Table/Abstract.php(955):
Zend_Db_Adapter_Abstract->insert('user', Array)

..and I would like to see the whole update statement before sent to the db to track what is wrong with it.

Thanks for the help!

Ari