Re: Sorting Paginated Results Question

2009-09-29 Thread Paul Redmond
I figured out the answer to my own question =) The original order I specified was: 'order' => array('Coupon.id' => 'DESC', 'Restaurant.tier'=>'ASC', 'Restaurant.name' => 'ASC'), I changed order to: 'order' => array("Coupon.id != 0 DESC", 'Restaurant.tier ASC', 'Restaurant.name ASC'), Hope this

Sorting Paginated Results Question

2009-09-28 Thread Paul Redmond
I have searched high and low for an answer to this question... I have a 1 to 1 relationship in my database. A Restaurant has one Coupon The coupon is optional, so the restaurant without coupons should be included in the result set, however, when I try to sort by restaurants that have a coupon f