Hard to say without seeing any code, but clearly the database insert is not getting a list.
On Friday, June 27, 2014 12:12:00 PM UTC-4, Cliff Kachinske wrote: > > > <https://lh4.googleusercontent.com/-7k58hj9gv7M/U62UdX1NG4I/AAAAAAAAAHA/9l6vaRZIxy0/s1600/Screenshot+from+2014-06-27+11%3A56%3A46.png> > > Web2py 2.8.2, if that matters. > > The manual at web2py.com says, "On relational databases they [list:string > fields] are mapped into text fields which contain the list of items > separated by |. For example [1,2,3] is mapped into |1|2|3|. > > I am getting something different. > > The field shown at the top of this post Inserts the following into the > Postgresql database. > > pandi3=> select distinct lots_used from job_materials where lots_used is > not null and is_active = 'T'; > lots_used > -------------------------- > |foo, bar, fubar, fubub| > (1 row) > > From the manual's description I expect something like > > foo|bar|fubar|fubub > > > I am using a custom validator that returns a list from the field. Use it > or not, I get the same results. > > How do I fix this? IS_IN_SET will not work here. > -- 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.