look into the online book for "list:reference" types. t hides the |4|6| 9 implementation details and does some of what you asked. It may do more select of what you need under the hood.
On Aug 17, 2:55 pm, apaterno <apate...@gmail.com> wrote: > Hi, I'm new at web2py, and I made a few applications, so, Its time to > go for a little more complicated work, and I'm having a problem with > multiselect fields. > > I'v 2 tables one table is for IPs and another table is for Hostnames. > One IP can have more that one hostname, so, I'm using multiple=true > for multiselect propouses. And It works really well, It stores the > multiple hostname IDs into a text field with the format 4|6|9|1 for > example, wich is great. but, How can I run a DB.select() for all the > records and transform 4|6|9|1 into Its equivalent hostnames ? is there > a way to do this with a simple (or not so) select ? Or should I run a > subquery with an split() for each one of the rows and transform them > back to hostnames before pass the result to the view ? > > Thanks in advance
