In other words, if I do this: IS_EMPTY_OR(IS_LENGTH(8))
It prevents longer length string but the empty field is inserted as None. I want to prevent both. On Monday, August 22, 2016 at 10:54:08 AM UTC-4, Ron Chatterjee wrote: > > Two question, if you don't mind. > > (1) requires = IS_NOT_EMPTY(IS_LENGTH(64)) Or requires = > IS_EMPTY_OR(IS_LENGTH(64)) Doesn't work. In other words, if I want to limit > the string field entry but also want requires not empty, how to go about it? > > (2) for my sql, do I still need length = 64 (or 255 etc)? Its redundant > when I define IS_LENGTH(64) or do I need both? > > > > > On Monday, August 22, 2016 at 7:49:42 AM UTC-4, Niphlod wrote: >> >> requires=IS_LENGTH(64) will limit insertion upon validation. the "length" >> attribute gets translated, wherever possibile, to backend-specific syntaxes. >> >> On Sunday, August 21, 2016 at 4:21:22 AM UTC+2, [email protected] wrote: >>> >>> How we limit string length in DAL? It seems length = 64 doesn't work. >>> >> -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
