Looks like you just forgot enclose your custom sql into brackets.
array(
'Post.status' => 0,
'Post.rank <=' => $rank,
'('.$sql.')'
)
On Sep 7, 1:56 am, "Dave Maharaj :: WidePixels.com"
<[email protected]> wrote:
> For some reason this query is pulling more results then that which is
> possible.
>
> I am running a contain
>
> $params = array('contain' => false,
> 'conditions' => array(
> 'Post.status' => 0,
> 'Post.rank <=' => $rank,
> $sql
> ),
> 'fields' => array('Post.id'));
>
> which produces this
>
> SELECT `Post`.`id` FROM `posts` AS `Post` WHERE `Post`.`status` = 0 AND
> `Post`.`rank` <= 0 AND `Post`.`title` LIKE '%mary%' OR `Post`.`description`
> LIKE '%mary%'
>
> So I get these id's returned
>
> Array
> (
> [0] => 139ea7
> [1] => 2a4370
> [2] => 3fb952
> [3] => 66bfb4
> [4] => 8197d5
> [5] => 87c28a
> [6] => 97fd0f
> [7] => a78629
> [8] => cbe69d
> [9] => e9915c
> )
>
> Yet there are only 5 Posts in the db that have a rank of 0, seems like its
> ignoring the rank and status and just and pulling the `Post`.`title` LIKE
> '%mary%' OR `Post`.`description` LIKE '%mary%'
>
> Any ideas why? Or how to only get id's where I am going wrong here?
>
> Dave
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
