Maybe store a pickled dictionary? so then when you select and load the object, you can reference its values...
Just a thought, Mart :) On Aug 17, 3: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
