<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.
