Thank you very much for answering me. It's been a while now (way too
much time in fact...) since I started to work on this basic paginated
listing with filter...Too bad that there is no system allowing you
(automatically) to associate your search criterias to the navigation
links. Seems like you have to do it manually. That's what I did. I
would really appreciate to be able to combine search criterias and
sorting at the same time.

If anyone has an idea on how to do that, please tell me.

BTW, when I use the sort method of the paginator helper, it works when
I click on the column header, but when I switch to another page using
the paginator helper links I get the following error : SQL Error:
1052: Column 'name' in order clause is ambiguous ... The link on the
column header has "sort:Participant.nom" but the paginator helper
links to reach the other pages have "sort:nom", hence the ambiguous
thing...

Any idea for that ?


On 18 juin, 11:32, leo <[EMAIL PROTECTED]> wrote:
> Another thought - changes in 1.2 RC1:
>
> >> Please read the release notes regarding LIKE and other SQL operators.
> >> That should be:
>
> >> $conditions = array("or"=>(array(
>
> >>         'edifici LIKE %?%' => $searchText,
> >>         'adreca LIKE %?%' => $searchText
> >> )));
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to