Sorry about the cryptic subject line... I have a few fields like category_id_1, category_id_2 and they're set up in mysql to be not Null and with a default value of 0.
Now on the controller/view side I have something like: $form->input( 'Venue.category_id_1', array( 'empty' => true, 'options' => $categories ) ); Now the problem is, if the blank option is set Cake tries to save a null to the field causing a mySQL error. How do I get it so that, if nothing is picked, instead of trying to save a blank to the field it uses the mySQL default value field? Zoltan www.yyztech.ca --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
