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
