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
-~----------~----~----~----~------~----~------~--~---

Reply via email to