Anyone?
On Apr 9, 8:51 pm, nc <[email protected]> wrote:
> I have a Search controller that handles search-related tasks in my
> project and one of the requirements is that given a query (let's say
> $query) it should search for $query in table a (model A), table b
> (model B), table c (model C), and table d (model D). This Search
> controller DOES NOT have a Search model associated with it (was not
> needed). It instead sets $uses = array('A','B','C','D'). It has to
> search using MySQL's fulltext search.
>
> Right now I'm trying to get it working with only 2 of the 4 models
> (because it'll be easy to expand out to 4 once I get this working)
>
> Currently what I have is this (all in search_controller.php):
>
> var $paginate = array('fields' => array('A.id', 'A.title',
> 'A.second'));
>
> And my pagination does this:
>
> $this->paginate('A', array("1" =>
> "1 AND WHERE MATCH(A.title,A.second) AGAINST('{$query}' IN BOOLEAN
> MODE ) UNION SELECT `B`.`id`, `B`.`name`, `B`.`type` FROM `b` AS `B`
> WHERE 1 AND MATCH(`B`.`name`) AGAINST('$query' IN BOOLEAN MODE )"
> ));
>
> Naturally I get an error because the query it uses to do count(*)
> fails. I would override the entire pagination thing if I had a model
> to override (I can't override A and B's pagination because I want it
> to work normally for other things).
>
> So is there anyway I can do this or do I have to resort to hacking
> stuff to get my functionality?
>
> Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
