Re: Problem with save method

$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 <kapilagrawal408@gmail.com> 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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.