Anthony, Thanks for the shove in the right direction.
An ajax callback processes that field and I had forgotten to run it through the validator. So the db was inserting the entire string instead of list members. On Friday, June 27, 2014 1:07:33 PM UTC-4, Anthony wrote: > > 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.
