I feel your pain man. Every time I search on the same topic I get generic responses like "Override the paginate function"....
Here seems to be an example: http://www.littlehart.net/atthekeyboard/2007/12/11/cakephp-pagination-with-a-habtm-relationship/ Haven't tested though. From the looks of it, you can replace the $this->findByName() with $this->query() (since they should return the same structure) and also stick a count in ur statement to populate paginateCount. See if it works. -- Baz L Web Development 2.0 http://WebDevelopment2.com/ On Feb 6, 2008 10:41 AM, DragonI <[EMAIL PROTECTED]> wrote: > > Thanks patcoll BUT I've already searched and read all of the threads > that I could find. Maybe my terminology is wrong manual query vs > custom query. > > 1st link - is NOT using $this->query, i.e. Simple query - mine is more > complex > > SELECT Bookmark.id, Bookmark.name, Bookmark.url, Bookmark.modified, > User.id, User.username > FROM bookmarks as Bookmark, users as User > WHERE Bookmark.user_id = $user_id > LIMIT ..... > > 2nd Link - was never answered - see Chad's posting > > 3rd Link - read this but they all cover "Custom Query" using cake > $conditions. > > > > On Feb 6, 11:09 am, patcoll <[EMAIL PROTECTED]> wrote: > > A search in this group helps: > > > > http://groups.google.com/group/cake-php/browse_thread/thread/f990a459... > > > > http://groups.google.com/group/cake-php/browse_thread/thread/d0cb3f77... > > > > For more tough issues: > > > > http://groups.google.com/group/cake-php/web/frequent-discussions > > > > On Feb 6, 10:28 am, DragonI <[EMAIL PROTECTED]> wrote: > > > > > I'm wondering if it's possible to use cake's pagination with a manual > > > query ($this->query)? > > > > > I understand that I have to determine the offset and I have to get the > > > total records myself. But I'm stumped because paginate is expecting > > > the model name. > > > > > Thanks. > > > --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---