Re: HELP - Search Pagination on three different models

2009-04-30 Thread TGurske

As a follow up - I ended up making a mysql view table with a UNION
join to include the content from all the tables I wanted to search.
Then I just searched that table.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



HELP - Search Pagination on three different models

2009-04-29 Thread Tim

I already have this and it works:
$this-paginate['conditions'] = MATCH($options) AGAINST('$search' IN
BOOLEAN MODE);
$this-set('projects', $this-paginate());

What I need now is a search page that will do the same search but on
three different tables. I made a search model/view/controller  and I
added the paginate and paginateCount functions as described here:
http://www.littlehart.net/atthekeyboard/2008/03/04/custom-cakephp-12-pagination-queries/

My idea is that I could do three different custom queries and then
combine them. My problem is that after days of messing with it all I
can get it to return is something similar to Resource id #329. I
don't know what that is or where to go with it - It is supposed to
return an paginated array.

Has anyone ever done anything like this?

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---