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