Lets say I have a form to modify my data model. The data model contains numeric values. In my view I use input fields to manage numeric values. When the controller creates the data row everything is fine as empty inputs are not handled in the mysql insert statement issued by cake. However when you want to modify an existing data row ,the mysql update statement from cake will contain your empty inputs. In the case of numeric values cake will render an empty input with '' in the update statement. This will be interpreted as "0" (at least in mysql 4.1), even if you define the default value as NULL in mysql. Of course I could manually set my data model values to null before I update it, but that does not seem right.
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
