Saturday, June 2, 2012

tell ajax pagination to order by 3 fields

Hi,

I am using the ajax pagination.
I have a default ORDER BY rule like ORDER BY price ASC, upload DESC

So all my results are automatically ordered by this rule.
Fine so far!

But now I have a search form, where I want to add a third sort option like "articlegroup"
Users can choose if they want to order articlegroup ASC/DESC.

And it seams, that - if that  articlegroup is selected and my URL looks like this:
... /sort:articlegroup/direction:asc
It is overwriting my default ORDER BY values.

I can see that in my sql logs, that the statement only does a ORDER BY articlegroup ASC.

Is there a way that I can add my default ORDER rules also into the URL?
Or can I tell the model, that my default rules always apply and other are only added behind my default rules?

How can I solve this?
Please help me!


--
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: