Re: [rentittoday] MySQL Error Creating Record: Field doesn't have a default value
Hi,
There are a couple of ways to get around this. If you want to give this field a default value when creating a record, you can do this directly in your mysql insert query. A checkbox, for example, will have a value of either 1 or 0. so if you want to set it to be unchecked, you'd use this:
rit_seal = '0',
If you don't want to put a value into it through the insert query, you can turn off strict mode before you execute you're query.
Put this code above where you create your INSERT query:
mysqlStrictMode( false );
Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/