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]<javascript:>
> > 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] <javascript:>.
>> 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.
