You have typo below :
db.define_table('users',
Field('address', *'*list:string')
It truncate the end?
How do you determine it is truncate? In the grid? If in grid() try to set
greater then 20 to maxtextlength parameters of the grid...
Richard
On Mon, May 5, 2014 at 3:34 PM, LoveWeb2py <[email protected]> wrote:
> Richard,
>
> My db.define_table('users',
> Field('address',list:string')
>
> use to be Field('address','string')
>
> Soon as I changed it to list:string it truncated all of the addresses in
> the DAL. When I iterate through the database
>
> users_list = db(db.users_id!=None).select()
>
> for row in users:
> print row.address
>
> brings back truncated addresses. Even if I switch the field back to string
> it still is truncated. However when I go to the database and look at the
> addresses they're not truncated at all.
>
>
> On Monday, May 5, 2014 2:32:16 PM UTC-4, Richard wrote:
>
>> Are you talking about field type or representation or requires that all
>> differents?
>>
>> Without code can't help...
>>
>> Sorry.
>>
>> Richard
>>
>>
>> On Mon, May 5, 2014 at 2:21 PM, LoveWeb2py <[email protected]> wrote:
>>
>>> I am using MYSQL. So it actually didn't affect the database itself. What
>>> it did was just change the way the data is represented in SQLFORM. Very
>>> interesting. How could I properly represent it?
>>>
>>>
>>> On Monday, May 5, 2014 2:11:28 PM UTC-4, Richard wrote:
>>>
>>>> If you didn't backup db before makee your change I guess no...
>>>>
>>>> Rollback as notting to do there, it is a migration matter and the way
>>>> web2py handle this process...
>>>>
>>>> If were create a new field, the old field would stay there, because
>>>> web2py migration don't delete field, but since you change field type,
>>>> web2py had try to make it best to handle the situation...
>>>>
>>>> Which DBMS do you use?
>>>>
>>>> If you have the data somewhere else, just reload them.
>>>>
>>>> Richard
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, May 5, 2014 at 2:02 PM, LoveWeb2py <[email protected]> wrote:
>>>>
>>>>> I had a list of addresses I was using on my user db and when I
>>>>> switched the field from string to string.list it truncated all of my
>>>>> values. I have over 1000 customers in there.
>>>>>
>>>>> Is there an explanation for this? It cut off the first and last
>>>>> character for example: 123 field road is now 23 field roa
>>>>>
>>>>> Is there any way to roll back???!
>>>>>
>>>>> --
>>>>> 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.
>>>>>
>>>>
>>>> --
>>> 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.
>>>
>>
>> --
> 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.
>
--
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.
