Nobody had the same issue ?
On 18 juin, 11:27, OLance <[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
> I've got an issue with the {$__cakeID__$} value in a finderQuery :
>
> I have a Resource model and a Mark model, with these associations :
> Resource hasMany Mark
> Mark belongsTo Resource
>
> Mark is a simple model with an id, a value and of course a
> resource_id. What I'd like to do is, instead of getting all my marks
> when fetching a Resource model, to compute the average mark for this
> Resource.
>
> So I tried to use the finderQuery param and obviously used {$__cakeID__
> $} to get my average calculated with the proper marks :
>
> "finderQuery" => 'SELECT AVG(Mark.value) AS average FROM res_marks AS
> Mark WHERE Mark.resource_id = {$__cakeID__$}'
>
> I'm not so sure I can use finderQuery for that, but I bet it's made
> for it... the problem is that it generates an wrong query when I try a
> $this->Resource->findAll() :
>
> SELECT AVG(Mark.value) AS average FROM res_marks AS Mark WHERE
> Mark.resource_id = 1, 2
>
> This is the generated query if I have two Resources of id 1 and 2 in
> my database... if I add a new one with id=5, it generates
> Mark.resource_id =1, 2, 5...
>
> I don't understand this behaviour, and I've found no one with this
> problem... does anyone have an idea on it ? Am I doing something
> wrong ?
>
> Thanks a lot,
> OLance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
