Just add a beforeSave callback in your model that unsets the field from $this->data if it is empty.
On Jan 25, 5:49 pm, "miggs" <[EMAIL PROTECTED]> wrote: > I'm sure the answer is right in front of me as it normally is, but I'm > just not seeing. I used the bake.php script to create the basic > scaffolding for my project. I then added a datepicker (from > frequency-decoder.com) to the date fields. It is working great, I > think it's a fantastic script. If I create a 'new' record, and I leave > the date fields blank, it works just fine, but if I go in and 'edit' > that same page, and leave the date fields blank, it gives me an error. > If I add a date to the fields in either 'new' or 'edit', it works just > fine. > > The SQL error I get when I turn on debug in the edit view is: > > 1292: Incorrect date value: '' for column 'dateSend' at row 1 > > I don't want to make this a required field and it is set to allow nulls > in mysql. Is there something I need to do so that if it's empty it > doesn't use `dateSend`='' in the SQL statement. > > Any help is most appreciated --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
