How to order by multiple columns with propel

symfony-1.4 propel
Radu Dragomir picture Radu Dragomir · Jan 3, 2011 · Viewed 9.8k times · Source

I need to sort a query by 2 columns. Is this possible using propel?

i tried:

$c->addAscendingOrderByColumn(self::COL1);
$c->addAscendingOrderByColumn(self::COL2);

but the second call to addAscendingOrderByColumn overrides the first one.

Regards, Radu.

Answer

macgyver picture macgyver · Dec 18, 2011

I was struggling with this issue and after reading this post I have been almost gave up... but suddendly I found this solution:

$criteria->addAscendingOrderByColumn(ClassPeer::COLUMN1)->addAscendingOrderByColumn(ClassPeer::COLUMN2);

In this way the second call to addAscendingOrderByColumn will add the order to the first one.

Related questions

How to use Sessions in Symfony?

Like in classic PHP we use the magic variables to start and create sessions, so how to do that in Symfony?

Read More
How to query NOT NULL with Doctrine?

I have table Test: Test: id | name 1 | aaa 2 | 3 | ccc 4 | aaa 5 | 6 | ddd I want result where name is NOT NULL: aaa ccc aaa ddd How can i get with: Doctrine_Core::getTable('Test')->findBy('name', NOTNULL??) <-doesnt working …

Read More
change month name to french

I have this code: <?php echo "'".$sgps_newsletter->getEmail()."' demande en ".date('d.M.Y', strtotime($sgps_newsletter->getCreatedAt())) ?> but the month name is appering in english. What can I do to show it …

Read More