$this->Manufacturer->id = $id;
you can also save() the data without doing a set() first, i.e. $this-
>Manufacturer->save($this->data);
the update would also get triggered if 'id' is part of the $this->data
array
On Sep 22, 11:25 pm, ORCC <[EMAIL PROTECTED]> wrote:
> In the blog tutorial, they use the save method both to save or update
> an existing record. I tried to take that idea for my application and
> had some trouble:
>
> My model is the following, with all default table names (i.e id is the
> primary key)
>
> class Manufacturer extends AppModel {
> var $name = "Manufacturer";
> var $validate = Array (/*validation stuff*/);
>
> //some other methods
>
> }
>
> And the controller is as follows
>
> class ManufacturersController extends AppController {
> var $name = "Manufacturers";
> var $helpers = array('Html', 'Form','Javascript');
> var $components = array('Session');
>
> function edit($id = 0) {
> if ($id) {
> $this->Manufacturer->set($this->data);
> $this->Manufacturer->set('id',$id);
>
> /*try to update the record*/
> $this->Manufacturer->save();
> }
> }
>
> }
>
> In the edit function I set the id attribute for the Manufacturer model
> as stated in the documentation; with this, the "save" method should
> update rather than create a new records. Altough, the application
> issues the following error message (here key 1 is the primary key, and
> 12 is a value of an existing id in the database table):
>
> Warning (512): SQL Error: 1062: Duplicate entry '12' for key 1
>
> $sql = "INSERT INTO `manufacturers`
> (`titulo`,`descripcion_es`,`descripcion_uk`,`descripcion_it`,`id`)
> VALUES ('F222','xxx,'xxx','xxxx',12)"
>
> Wich attribute I have to set in order of the save method generate a
> UPDATE query instead of an INSERT one?
>
> Thanks in advice.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
