Solved it!! Thank you so much everyone!
UPDATE YourTable SET YourColumn = CONCAT('|', YourColumn, '|');
Here is the SQL query if you're using MYSQL:
On Monday, May 5, 2014 4:36:56 PM UTC-4, Anthony wrote:
>
> Internally, when you store a list of items in a list:string field, web2py
> converts the list to a single string, with list items separated by the "|"
> character. If you convert to a list:string field, you will need to modify
> all of the existing records by wrapping them in "|" characters. So, for
> example, "123 Home St." should be changed to "|123 Home St.|".
>
> Please try this on a dev copy of the db before messing around with the
> production database, though.
>
> Anthony
>
> On Monday, May 5, 2014 4:17:02 PM UTC-4, LoveWeb2py wrote:
>
>> Derek,
>>
>> I want to be able to add multiple addresses for one customer using the
>> dropdown instead of having to create another new record.
>>
>> On Monday, May 5, 2014 4:15:00 PM UTC-4, Derek wrote:
>>>
>>> Why are you doing this? Are you just trying to change the widget that is
>>> used to display and edit?
>>>
>>> On Monday, May 5, 2014 1:05:38 PM UTC-7, LoveWeb2py wrote:
>>>>
>>>>
>>>> Rebooted and the address shows up in one field now (not spread across
>>>> 10), but it is still truncated. If I switch the field back to string and
>>>> reboot the ip address appears fine... I really need it in a list form if
>>>> possible, but if I can't i'll deal with a string
>>>>
>>>
--
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.
