Tuesday, October 4, 2011

Simple deleteAll() yet I am stuck..

This is the query for deleting multiple row.

$query = "DELETE FROM users_modules WHERE projects_id='$projects_id'
AND project_modules_id='$projectModuleID'";

I tried this

$delCond['conditions'] = array('projects_id'=>$projects_id);
$delCond['conditions'] = array('AND'=>array('project_modules_id'=>
$projectModuleID));
$this->ProjectModule->UsersModule->deleteAll($delCond);

But the delete query is not working. It shows some mysql error as a
select rather than delete.

I am executing this in projects_module_controller.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: