dear all, i just learn the cake in a week. and i start to get confused with how to paginate a custom query. if i have a more complex table:
users: id, group_id, name, password groups: id, name roles: id, name group_roles id, role_id, group_id then i have a query: "SELECT users.name FROM users JOIN groups ON users.group_id=groups.id JOIN group_roles ON groups.id=group_roles.group_id JOIN roles ON group_roles.role_id=role.id WHERE roles.name='someRole'; how to page it? does the Paginator can paginate it? just like paginates a model selection. if i modify the model, it would be bad. 'coz i think it's not really reusable. so, can somebody help me,... Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
