Thanks, worked perfectly.
On Wed, Jun 20, 2012 at 9:17 AM, dogmatic69 wrote:
> Sorry Cake creates the fields as Model__filed so it should be 'group' =>
> 'Timesheet.user_id, Timesheet.date HAVING Timesheet__count_name > 1',
>
> On Tuesday, 19 June 2012 23:52:43 UTC+1, elogic wrote:
>>
>> Tha
Sorry Cake creates the fields as Model__filed so it should be 'group' =>
'Timesheet.user_id, Timesheet.date HAVING Timesheet__count_name > 1',
On Tuesday, 19 June 2012 23:52:43 UTC+1, elogic wrote:
>
> Thanks,
>
> This is what I ended up doing in my records controller function but I get
> the fo
Thanks,
This is what I ended up doing in my records controller function but I get
the following error:* Column not found: 1054 Unknown column 'count_name' in
'having clause'
*
$this->Timesheet->virtualFields = array(
'count_name' =
Cake does not support HAVING but you can put it in the group as a string.
Something like the following:
$this->Timesheet->virtualFields = array(
'count_name' => 'COUNT(id)'
);
$this->Timesheet->find(
'all',
array(
'fields' => array(
'Timesheet.user_id',
'Timesheet.date',
'count_name'
),
'group' =
Hi All,
How do I go about generating the following SQL line using cakePHP from the
timesheets controller?
SELECT user_id, date, count(id) as count_name FROM `timesheets`GROUP BY
user_id, date HAVING count_name > 1 ORDER BY count_name;
Basically it is just checking for double up records mathchi
