have you read
http://www.littlehart.net/atthekeyboard/2008/03/04/custom-cakephp-12-pagination-queries/
hth - S
2008/5/5 Louie Miranda <[EMAIL PROTECTED]>:
> Greetings,
>
> I wanted to paginate my custom SQL queries. Is this possible on Cake 1.2?
>
> function search($keywords = null)
> {
> $this->checkSession();
>
> $keywords = $this->data['Search']['keywords'];
>
> $sql = "SELECT * FROM web_logs as WL where username LIKE
> '%$keywords%' order by wl.date_created desc";
> $this->set('activities', $this->Statistic->query($sql));
> //$this->set('activities', $this->paginate('Statistic')); *// Did
> not work?*
> }
>
> Thanks
> --
> Louie Miranda ([EMAIL PROTECTED])
> http://www.axishift.com
>
> Security Is A Series Of Well-Defined Steps
> chmod -R 0 / ; and smile :)
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
