Re: Simple deleteAll() yet I am stuck..

Hello,

1.) When posting a problem to the group, especially database related problems, posting the "some mysql error" is vital for us to help you.

2.) You are overwriting the conditions array in line 2 of your example:
Try this instead (the 'AND' behavior is the default in cakephp, so you can safely ommit it):

$delCond['conditions'] = array(
    'projects_id'=>$projects_id,
    'project_modules_id'=> $projectModuleID
)

Kind regards
Thomas

On 04.10.2011 13:31, sathyashrayan wrote:

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.