Using MySQL and the table definition is just:
db.define_table('newtable',
Field('Name','string'),
Field('Comments', string', length=499)'
migrate=False)
On Wednesday, April 9, 2014 8:09:19 AM UTC-4, Niphlod wrote:
>
> what's the table definition ? what backend are you using ?
>
> On Wednesday, April 9, 2014 9:06:12 AM UTC+2, Austin Taylor wrote:
>>
>> Wow thanks for the quick reply! I did try the length=499, but I still
>> get the validator error. Do I need to restart web2py?
>>
>> On Wednesday, April 9, 2014 3:00:49 AM UTC-4, Niphlod wrote:
>>>
>>> Field('whatever')
>>>
>>> means really
>>>
>>> Field('whatever', 'string', length=255)
>>>
>>> it gets a default "requires" that resembles IS_LENGTH(maxsize=255)
>>>
>>> if you need more of that, use length=morethan255
>>>
>>> On Wednesday, April 9, 2014 8:54:40 AM UTC+2, Austin Taylor wrote:
>>>>
>>>> I'm creating a grid using grid=SQLFORM.smartgrid(db.mydatabase,
>>>> user_signature=True)
>>>>
>>>> when I try to update one of the fields using the edit button I get
>>>> enter from 0 to 255 characters. The field already has over 255 characters
>>>> in it because its in the database, but I cannot add extra characters to
>>>> the
>>>> field.
>>>>
>>>> Any help is appreciated. I looked all over for the error "enter from 0
>>>> to 255 characters"
>>>>
>>>>
>>>>
--
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.
