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