Hi, I'm guessing your primary key field is misspelled? You could try replacing ID with id (lower case).
Cheers, OJ On Nov 10, 2:26 am, dpinion <[email protected]> wrote: > Greetings, > I am a bit new to cake, and am diving in via the cookbook. I have a > simple app I am trying to develop, and am modifying the cookbook > example to fit it. So far everything has worked great with one > exception. I have an edit form that when I go to it it fills in with > the DB data from the record previously selected (on the index page). > However, once I change any information and try to submit it, I receive > the following: > > SQL Error: 1062: Duplicate entry '1' for key 1 [CORE/cake/libs/model/ > datasources/dbo_source.php > > The query string tells me that the form is attempting to perform an > INSERT Into instead of an UPDATE command on the database, causing the > failure. I am not sure why it is doing this... Here is my edit.ctp > content: > > <h1>Edit Comment</h1> > > <?php > echo $form->create('Comment', array('action' => 'edit')); > echo $form->input('name'); //text > echo $form->input('com_date'); //day, month, year, hour, minute, > meridian > echo $form->input('comment', array('rows' => '3')); > echo $form->input('ID', array('type' => 'hidden')); > echo $form->end('Update Information'); > ?> > > and here is the edit section from the controller: > > function edit($id = null) { > $this->Comment->id = $id; > if (empty($this->data)) > { > $this->data = $this->Comment->read(); > } > else > { > if($this->Comment->save($this->data)) > { > $this->Session->setFlash('Your comment has been updated. > ','/comments/'); > } > } > > } > > any suggestions as to what I am doing wrong? > > Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
