djgjohng
Posts: 28
|
| Posted: 07/17/2008, 5:56 PM |
|
Getting this error on a Boolean field on a record form where the checked value is set as true, unchecked as false.
If set as 1, 0 there is no problem in posting data - no error.
MySQL field is setup with 'true','false' as options for enum field type.
Any clues?
|
 |
 |
mentecky
Posts: 321
|
| Posted: 07/17/2008, 6:15 PM |
|
MySQL doesn't have a real boolean type anymore. Set it to "1,0" and it should work ok.
Rick
_________________
http://www.ccselite.com |
|
|
|
djgjohng
Posts: 28
|
| Posted: 07/17/2008, 7:04 PM |
|
Thanks Rick. Changed data type for the checkbox field to Text instead of Boolean and works fine.
|
|
|
|
|
