I just had a similar problem and I used following syntax to get it
working:
$model->findAll(array("CONCAT(`path`, '\\\\' ,`filename`)" =>
$files));
$files is just an array of strings (absolute filepaths). In SQL it
looks like:
...WHERE CONCAT(`path`, '\\', `filename`) IN ('path1', 'path2',
'path3', ...)
Little late but maybe it helps,
Michael
On 29 Mai, 16:03, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> If I would get all the record of a model where the SQL condition is
> CONCAT('Field1','Field2')
> How have I to set the condition on findAll?
>
> $conditions=array("CONCAT(Field1,Field2)"=>"LIKE &.....&"); is wrong
>
> What is the correct form?
> Many Thanks
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
