fixed in trunk
On Oct 15, 5:42 pm, Bob_in_Comox <rwstj...@gmail.com> wrote: > Using web2py 1.87.2 with sqlite > > I need to store and retrieve a list of strings from a multple select. > I have a case where the list can be the empty list []. It will encode > to the datebase as '||', but will decode to ['|'], not []. > > The current gluon.sql.py is: > > def bar_encode(items): > return '|%s|' % '|'.join(bar_escape(item) for item in items if > str(item).strip()) > > def bar_decode_string(value): > return [x.replace('||','|') for x in string_unpack.split(value) if > x.strip()] > > I believe the following would fix this: > > def bar_decode_string(value): > return [x.replace('||','|') for x in > string_unpack.split(value[1:-1]) if x.strip()]