Re: CakePHP: How to remove LEFT JOIN in updateAll()

2013-08-05 Thread Indrajeet Singh
Hi All, You can change in function class BriefcaseComponent extends Object{ function delete($id){ $names = array('deleted' => '0'); $conditions = array("FilesFolders.instance_id" = '$id); $this->FilesFolders->updateAll($names, $conditio

Re: CakePHP: How to remove LEFT JOIN in updateAll()

2013-08-05 Thread Indrajeet Singh
On Wednesday, 12 November 2008 13:27:10 UTC+5:30, Kryptonian wrote: > > Hi, I have this problem that if my model uses a var $belongsTo = array > (), my updateAll() generated statement was affected with this error > message: > > UPDATE `files_folders` AS `FilesFolders` LEFT JOIN `course_files`

Re: CakePHP: How to remove LEFT JOIN in updateAll()

2008-11-12 Thread Serge Rodovnichenko
:-) $this->controller->FilesFolders->unbindModel(array( 'belongsTo' => array_keys($this->controller->FilesFolders->belongsTo) )) On 12 нояб, 10:57, Kryptonian <[EMAIL PROTECTED]> wrote: > Hi, I have this problem that if my model uses a var $belongsTo = array > (), my updateAll() generated state

Re: CakePHP: How to remove LEFT JOIN in updateAll()

2008-11-12 Thread Mathew
I've had the same problems with updateAll. I can't remember if setting the recursive to -1 solved the problem. $this->controller->FilesFolders->recursive = -1; If that doesn't work you can call unBind. --~--~-~--~~~---~--~~ You received this message because you a

CakePHP: How to remove LEFT JOIN in updateAll()

2008-11-12 Thread Kryptonian
Hi, I have this problem that if my model uses a var $belongsTo = array (), my updateAll() generated statement was affected with this error message: UPDATE `files_folders` AS `FilesFolders` LEFT JOIN `course_files` AS `CourseFile` ON (`FilesFolders`.`account_id` = `CourseFile`.`id`) SET `FilesFold