I am trying to submit a form with 100's of numerical INT fields. On average only around 50% of them will be completed and should default to 0 if left blank. However if no value is entered Cake tries to enter NULL values for these fields and I get nasty SQL errors. This issue has been raised in the past:
https://trac.cakephp.org/ticket/5141 http://groups.google.com/group/cake-php/browse_thread/thread/a0b1a35c1909d5db http://groups.google.com/group/cake-php/browse_thread/thread/47b6b4a5715d32cb I have looked at the ticket raised and I bow down to superior knowledge that Cake treats such fields in the proper manner, but this still doesn't help me resolve my issue. Can someone inform me how I should configure my form and/or table so that the user can skip any fields that do not have a numerical value yet when inserted into the database these values will default to 0? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
