Monday, June 4, 2012

Re: How to order paginated results for more than one order condition?

I managed to handle the situation to a certain point.
Depening in my search, I get now different order by consitions! Fine so far!
For example with this search: 
/search 
I have the query order by typeA asc, typeB desc

When I have this url
/search/sort:typeC/direction:desc/
the order condition should be this: order by typeA asc, typeB desc, typeC asc

debug($this->paginate);
$results = $this->paginate('Objekt');

the debug is returning the correct query eg. the correct statement!

But performed query is always order by typeC desc

Just in the moment this code will be happen
$this->paginate('Objekt');

the order part gets overwritten from the values in the URL.

This drives me mad, I lost already the whole day on it...

Is there anybody out there who can support me?

Please help!!




--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: