$this->request->data['Event]['image] = false; OR unset($this->request->data['Event]['image]);
$this->Event->save($this->request->data); Andras Kende On Aug 7, 2013, at 6:01 AM, kapil agrawal <[email protected]> wrote: > Hi! > > I am a new bee in cakePHP, look at following scenario > > I have following tables structure > > ------------------------------------------------------------------------------------------------------------------------------------------------------- > Table name: events > Field Type Null Default Comments > id int(11) No Contains id of Event > category_id int(11) No Contains id of category to which event > belongs > client_id int(11) No Contains id of client to which event > belongs > name varchar(255) No Contains name of Event > venue varchar(255) No Contains venue of event > description text No Contains description of event > image varchar(255) No no_image.jpg contains name of image > start_date date No Contains start date of event > end_date date No Contains end date of event > created datetime No Contains date when event was > added > modified datetime No Contains date when event was > last modified > ------------------------------------------------------------------------------------------------------------------------------------------------------- > > When adding an event, i want to save all fields except 'image',, to do so i > am trying to save method with syntax > > $this->Event->save($this->request->data, true, array("Event.name", > "Event.venue", "Event.description", "Event.start_date", "Event.end_date", > "Event.created", "Event.modified", "Event.category_id", "Event.client_id")) > > But this statement result in > > INSERT INTO `mydb`.`events` (`modified`, `created`) VALUES ('2013-08-07 > 18:20:39', '2013-08-07 18:20:39') > > instead of > > INSERT INTO `mydb`.`events` (`category_id`, `client_id`, `name`, `venue`, > `description`, `start_date`, `end_date`, `modified`, `created`) VALUES (1, 1, > 'My Event', 'Jaipur', 'My Event at Jaipur', '2013-08-07', '2013-08-07', > '2013-08-07 18:20:39', '2013-08-07 18:20:39') > > Also when i try to update image field like > > $this->Event->save(array("Event"=>array("id"=>$this->Event->id, > "image"=>"myimage.jpg", true))) > > it produces query like > > UPDATE `mydb`.`events` SET `id` = 84 WHERE `mydb`.`events`.`id` = '84' > > > i am highly tired, please help me thanks in advanced. > > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php. > For more options, visit https://groups.google.com/groups/opt_out. > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.
