Alfonso, What you use case?
As HTML radio box doesn't allow NULL and by default web2py set bool field type as check box by default, it doesn't implment the NULL state as it doesn't make much sens to do it as false or NULL result in the same HTML tag state. You would need to use other widget representation of boolean field to achieve what you want (dropdown for instance). http://ux.stackexchange.com/questions/46091/html-best-input-type-for-boolean-values-selection I am not sure I do understand what you exactly try to achieve, what I do understand is that you want to leave NULL value in case a boolean field is not populate (neither True or False is selected)... Do I understand it right? I would use IS_IN_SET(['None', 'True', 'False']) which should result in a dropdown field. Not sure if web2py with properly convert these values in NULL, TRUE, FALSE... You can try. Richard On Thu, Jul 7, 2016 at 3:50 PM, Alfonso Serra <aleonse...@gmail.com> wrote: > MySQL with TINYINT as booleans: > > db = DAL("mysql://....", pool_size = 10, check_reserved=None, migrate= > True) > db._adapter.types['boolean']='TINYINT(1)' > db._adapter.TRUE = 1 > db._adapter.FALSE = 0 > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
