On Dec 10, 4:13 am, Tanay <[EMAIL PROTECTED]> wrote:
> $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?
'Expense.Name LIKE'=>' S%'
or
'Expense.Name LIKE ?%'=>' S'
https://trac.cakephp.org/changeset/7075
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
