Zend_Db_Adapter_Abstract#update() will automatically quote identifiers in
the $data array (aka $bind), but not the $where array. Have you tried
without manually quoting the $data array?
$data = array('default' => 0);
$where = array("{$db->quoteIdentifier('default')} = ?" => 1);
$db->update('my_table', $data, $where);
--
*Hector Virgen*
Sr. Web Developer
Walt Disney Parks and Resorts Online
http://www.virgentech.com
On Fri, Sep 3, 2010 at 6:54 AM, debussy007 <[email protected]> wrote:
>
> By the way, with fetchAll I got it working :
>
> function getDefaultTypeAppointment($doctorId) {
> $db = Zend_Registry::get(My_Constant_App::REG_DB_ADAPTER);
> $sql = 'SELECT * FROM types_appointment ' .
> 'WHERE doctor_id = ' . $doctorId . ' AND `default` = 1';
> return $db->fetchRow($sql);
> }
>
>
> I have only problems with update above :-(
> --
> View this message in context:
> http://zend-framework-community.634137.n4.nabble.com/Quote-reserved-keywords-tp2525558p2525707.html
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
