ZF-5680: Zend_Db_Select problem with 2 order by and limit
Description
I'm using a MSSQL database.
When I use 2 or more order() method and set a limit (see example below) that resultset does not respect choosed orders
$oSelect = new Zend_Db_Select($db);
$oSelect
->from('Table_Name')
->where('condition')
->order('field_1 any_order')
->order('field_2 any_order')
->limit(int_value)
;
$aResult = $db->fetchAll($oSelect);
P.S.: Sorry my bad english!!
Comments
Posted by José Domingos Grieco (jdgrieco) on 2009-02-03T09:34:44.000+0000
That's same bug, but a little bit diferent construction
Posted by José Domingos Grieco (jdgrieco) on 2009-02-03T09:37:03.000+0000
That's same bug, but with a little bit diferent construction
Posted by old of Satoru Yoshida (yoshida@zend.co.jp) on 2009-05-30T19:39:23.000+0000
It duplicates ZF-4099.