The beforeSave looks ok, except that '--' is not empty, so the unset()
won't be called. Perhaps you want to do a regex check instead of
empty() ?
On Dec 31, 10:44 am, Jamie <[EMAIL PROTECTED]> wrote:
> Apologies as I'm new to cake, as well as MVC.
>
> I have a table with a field called "obtained_date", where null is
> allowed.
>
> I have the edit action in the controller which was created by bake:
>
> function edit($id = null) {
> if (empty($this->data)) {
> if (!$id) {
> $this->Session->setFlash('Invalid id for
> Skater');
> $this->redirect('/skaters/index');
> }
> $this->data = $this->Skater->read(null, $id);
> $this->set('franchises',
> $this->Skater->Franchise->generateList());
> } else {
> $this->cleanUpFields();
> if ($this->Skater->save($this->data)) {
> $this->Session->setFlash('The Skater has been
> saved');
> $this->redirect('/skaters/index');
> } else {
> $this->Session->setFlash('Please correct
> errors below.');
> $this->set('franchises',
> $this->Skater->Franchise->generateList());
>
> }
> }
> }
>
> In the model for Skater, I have specified a beforeSave() function as:
>
> function beforeSave()
> {
> // when no obtained_date is set, ensure that the string is
> empty.
> // without this, it would fail with 1292: Incorrect date
> value: '--'
> if (empty($this->data['Skater']['obtained_date']))
> {
> unset($this->data['Skater']['obtained_date']);
> }
>
> return true;
> }
>
> Yet, I still receive a sql error when the form I'm submitting doesn't
> specify an obtained date. The error is:
>
> SQL Error: 1292: Incorrect date value: '--' for column 'obtained_date'
> at row 1.
>
> Can someone help me understand what else I have to do to clean the
> data and ensure that I can persist a null value?
>
> Thank you in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
