I would suggest you to enable db profiler and see the queries on your firephp console.
scs On Mon, Mar 29, 2010 at 11:59 AM, Sergio Rinaudo <[email protected]> wrote: > Yes, ok for the try-catch to get exceptions and to echo a select query, > but if I want to get the update query string? > > > Sergio Rinaudo > > > > >> Date: Mon, 29 Mar 2010 11:13:04 +0300 >> From: [email protected] >> To: [email protected] >> CC: [email protected] >> Subject: Re: [fw-general] Get query and error messages from $db->update >> >> If you form the query in the following way >> $filter = $this->select()->from($this->_name, array('id', 'label')); >> then you can echo it directly >> echo $filter; >> >> And if there is a db/sql syntax error, it already throws exception. >> For example, let's say you do not have a field named "idd" in your >> table structure >> $filter = $this->select()->from($this->_name, array('idd', 'label')); >> Then the above sql statement will throw an exception telling you that >> there is no field with name idd in the related table.. >> >> scs >> >> On Mon, Mar 29, 2010 at 11:01 AM, Sergio Rinaudo >> <[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 >> > >> > >> > >> > ________________________________ >> > Vuoi scaricare gli allegati? Guardali in anteprima, su Hotmail! > > ________________________________ > Chiacchiera con i tuoi amici via Webcam su Messenger. Videochiamali!
