In your model declaration, did you use the primaryKey property?
var $primaryKey = 'id_number';
On Jan 5, 5:51 pm, Travis <[EMAIL PROTECTED]> wrote:
> HI,
>
> I'm trying to update a record through the controller action customers/
> edit/id_number. This loads a form prepopulated with the customer data
> associated with id_number. The form posts to customers/edit.
>
> The id_number field is an auto increment integer that is the primary
> key on the table. When I try to call Save() or Update() in my
> controller, I get sql errors. Here's the latest attempt at my
> controller logic. Any advice would be appreciated !
>
> function edit($id = null){
> if (empty($this->data))
> {
> $this->Customer->id = $id;
> $this->data = $this->Customer->read();
> }
> else
> {
> $this->Customer->save($this->data['Customer']);
>
> $this->flash('Your customer data has been updated.',
> '/customers');
>
> }
> }
>
> When I use $this->Customer->Save() this is the message I recieve ...
>
> Query: INSERT INTO `customers`
> (`name`,`street`,`city`,`state`,`zip`,`phone`,`id`,`modified`,`created`)
> VALUES
> ('thomas','','Lafayette','LA','70517','337-555-5555','0','2008-01-05
> 17:48:02','2008-01-05')
>
> Warning (512): SQL Error: 1062: Duplicate entry '0' for key 1 [CORE/
> cake/libs/model/datasources/dbo_source.php, line 440]
>
> When I use $this->Customer->Update() this is the message I recieve
>
> Query: update
>
> Warning (512): SQL Error: 1064: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near '' at line 1 [CORE/cake/libs/model/
> datasources/dbo_source.php, line 440]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
