Re: Join Table in Conditions of a findAll

2006-08-21 Thread DJ Spark
from the cakephp manual, quoted below, you can see how adding a few parameters to the findAll function you can limit the number of rows retrieved: example: $this->User->findAll('',null, '', 20, 2); this gets the second page of results, containing 20 items each. If you use a variable $page, for e

Re: Join Table in Conditions of a findAll

2006-08-21 Thread ShepherdWeb
I'm working on a similar scenario right now. I haven't found a solution yet. Maybe some seasoned Cake veterans will chime in on this --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to

Re: Join Table in Conditions of a findAll

2006-08-21 Thread [EMAIL PROTECTED]
Thanks ShepherdWeb! Is there a way to limit the results like you can with the findAll? We'd like to do pagination when you navigate to a Category. Can we do this? or do we just have to dump all the data from the db every time? Thanks again, Jimmy --~--~-~--~~~---~

Re: Join Table in Conditions of a findAll

2006-08-21 Thread ShepherdWeb
@Jimmy - Check out this WIKI entry: http://wiki.cakephp.org/docs:method:read I hope this helps! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@goog

Join Table in Conditions of a findAll

2006-08-21 Thread [EMAIL PROTECTED]
I have a database schema with categories and products that are joined with categories_products table. This makes it so a product can be assigned to multiple categories. I would like to find all of the products that belong to a category. I've tried: $this->Product->findAll(array("CategoriesProdu