Here some examples I use in pagination:
1st example:
$param['Bild.name LIKE'] = '%'.trim($this->data['Bild']['name']).'%';
$this->paginate = array(
'limit' => 10,
'order' => array ('Bild.name' => 'asc'),
'contain'=> array(
'User'=> array('fields'
=>array('User.id','User.name')),
'Mandant'=> array('fields' =>array('Mandant.name'))),
'url' => $paginator_params,
'recursive' => 2,
'conditions' => $param
);
2nd example:
Even more complex with an or condition:
$paramhotel['or'] = array (
'Hotelmaster.name LIKE' =>
'%'.strtoupper(trim($this->data['Hotel']['name'])).'%',
'Hotel.name LIKE' =>
'%'.strtoupper(trim($this->data['Hotel']['name'])).'%');
$this->paginate = array(
'limit' => 10,
'order' => array ('Hotel.name' => 'asc', 'Saison.id' =>
'desc'),
'contain'=> array(
'Hotelmaster'=> array( 'conditions'=> array
('Hotelmaster.deleted' => '0') ,
'Praefix'=>array('fields'=>array('Praefix.name'))),
'Ort'=> array('fields'=> array('Ort.name','Ort.id')),
'Praefix',
'Zielgebiet'=> array('fields'=>
array('Zielgebiet.name','Zielgebiet.id')),
'Saison',
'Sprache',
'Mandant',
'User'=> array('fields'=> 'User.name')),
'url' => $paginator_params,
'conditions' => $paramhotel
);
HTH!
Anja
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[EMAIL PROTECTED] Im Auftrag von Tanay
Gesendet: Mittwoch, 10. Dezember 2008 04:14
An: CakePHP
Betreff: $this->find not interpreting "LIKE"
$expenses=$this->Expense->find('all',array(
'conditions'=> array(
'Expense.Name'=>'LIKE S%' )));
the query generated from sql dump:
SELECT `Expense`.`id`, `Expense`.`name`, `Expense`.`description`,
`Expense`.`amount`, `Expense`.`date`, `Expense`.`tenant_id`, `Tenant`.`id`,
`Tenant`.`name` FROM `expenses` AS `Expense` LEFT JOIN `tenants` AS `Tenant` ON
(`Expense`.`tenant_id` = `Tenant`.`id`) WHERE `Expense`.`Name` = 'LIKE S%'
========
at the end i want 'Expense'.'name' LIKE 'S%'
but its giving `Expense`.`Name` = 'LIKE S%'
whats wrong with my cakephp syntax?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
