ZF-5680: Zend_Db_Select problem with 2 order by and limit

Issue Type: Bug Created: 2009-02-03T09:23:57.000+0000 Last Updated: 2011-12-08T07:53:44.000+0000 Status: Resolved Fix version(s): Reporter: José Domingos Grieco (jdgrieco) Assignee: Satoru Yoshida (satoruyoshida) Tags: - Zend_Db_Select

Related issues: - ZF-4099



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);
    ->order('field_1 any_order')
    ->order('field_2 any_order')
    $aResult = $db->fetchAll($oSelect);

P.S.: Sorry my bad english!!


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 ( on 2009-05-30T19:39:23.000+0000

It duplicates ZF-4099.

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.