Cool, will this show the combined query if I'm using parameters e.g.
$id = 5; $sql = "SEELCT id FROM table WHERE id = ?"; $row = $this->db->fetchOne( $sql, $i ); Will it show: SELECT id FROM table WHERE id = 5 or SELECT id FROM table WHERE id = ? Thnx On Mon, Mar 29, 2010 at 1:09 AM, Narinder Chandi < [email protected]> wrote: > Hi. Something like this will work: > > public function dumpSQL() > { > $db = Zend_Db_Table::getDefaultAdapter(); > $dbProfiler = $db->getProfiler(); > $dbQuery = $dbProfiler->getLastQueryProfile(); > $dbSQL = $dbQuery->getQuery(); > > print_r($dbSQL); > } > > Regards, > > Narinder. > -- > > ______________________________________________________ > | Narinder Chandi, Director, > | ToolBox Systems Limited, Surrey, England, UK. > | tel : +44 (0)1372 720117, mob : +44 (0)7973 512495 > | www : http://www.toolbox.uk.com > | Skype : NarinderChandi > | LinkedIn : http://www.linkedin.com/in/toolboxsystems > | Twitter : @ToolBoxSystems > |______________________________________________________ > | Consultancy * Development * Support > |______________________________________________________ > > > on 29/03/2010 09:01, Sergio Rinaudo at [email protected] wrote: > > > > > Hi everybody, > > if I construct an update query programmatically using Zend_Db, how can I > get > > this query and how to get what is the problem if the query fails? > > Thanks > > > > Sergio Rinaudo > > > > > -- ----------------------------------------- Mark Steudel P: 206.375.7244 [email protected] . : Work : . http://www.mindfulinteractive.com . : Play : . http://www.steudel.org/blog
