Re: Paginate Custom Sql ..... Is there a better way to do this ?

On Mon, Jul 21, 2008 at 7:41 PM, mrconfused [EMAIL PROTECTED] wrote: Dave, I looked at that link and I am not getting the same results as my custom query with no pagination... Here's the old custom query : I wrote a blog posting a while back about doing custom pagination. Might help you

Re: Paginate Custom Sql ..... Is there a better way to do this ?

Dave, I looked at that link and I am not getting the same results as my custom query with no pagination... Here's the old custom query : $q = SELECT Member.id, Member.fname, Member.lname, Profile.gender, Profile.primaryPhotoSrc FROM members Member JOIN profiles Profile ON Member.id =

Paginate Custom Sql ..... Is there a better way to do this ?

Hello, I wanted to know if there is a better way to do this ? //my old way of getting all my friends but has no pagination. class FriendsController extends AppController { var $name = 'Friends'; function view($memberId = null) { if (!isset($memberId) ){

Re: Paginate Custom Sql ..... Is there a better way to do this ?

You can combine Paginator and Containable to do this, and you would probably run the search against the Member model. http://lampable.blogspot.com/2008/07/merging-containablebehavior-and.html On Jul 17, 11:55 am, mrconfused [EMAIL PROTECTED] wrote: Hello, I wanted to know if there is a better