Re: Pagination using multiple models and custom queries

2006-09-08 Thread codecowboy
Thank you. I am looking into that snippet now. Does anyone know whether or not it is easy to integrate the pear datagrid tool into cake? Thank you, codecowboy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake

Re: Pagination using multiple models and custom queries

2006-09-08 Thread AD7six
Hi Codecowboy, The problem with pulling data from more than one table, is that if it triggers more than one sql statement you canĀ“t apply a sort to it. This means that with the execption of belongsTo HasOne sorting queries becomes "difficult". What you describe is a grid sorting rather than pagi

Re: Pagination using multiple models and custom queries

2006-09-08 Thread codecowboy
Sohei Okamoto wrote: > I haven't tried this yet, but I think this is what you are looking for. > http://wiki.cakephp.org/tutorials:pagination > > It looks promising. > > Sohei Thanks Sohei, but we have already looked into that it doesn't seem to work. We are looking for a pagination tool that t

Re: Pagination using multiple models and custom queries

2006-09-06 Thread Sohei Okamoto
I haven't tried this yet, but I think this is what you are looking for.http://wiki.cakephp.org/tutorials:pagination It looks promising.Sohei --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post t

Pagination using multiple models and custom queries

2006-09-06 Thread codecowboy
Hi, I'm working on creating an index of a certain models, however I want to be able to take columns from several tables and be able to sort and paginate according to any of those columns. I was wondering if anyone knew the best way to do this. Also, I would like to know if I could create custom qu