I think (base on the source code), You can use paginate() function in
1.2 with array.
so do the query first with custom sql query, then pass the result into
controller pagination methods.
i think it will work ;)
adwin
On Oct 19, 4:55 am, austint01 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am using pagination in 1.2.
> is it possible to filter my results by looking at records in related
> models using pagination?
>
> $filters = array("
> lower(Applicant.fname) like '%".low($search)."%'
> OR lower(Applicant.personal) like '%".low($search)."%'
>
> OR lower(Education.schoolname) like '%".low($search)."%'
> ");
>
> but Education.schoolname creates an SQL error as the SQL query is only
> looking at Applicant e.g. SELECT FROM `applicants` WHERE... etc.
>
> is it possible to filter my results using related models using
> pagination?
>
> thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
