actually i ended up reading an interesting thread on this matter this morning, had good stuff on storing custom types. May actually be a little closer to what you had mentioned (a list vs a dictionary - otherwise close enough).
here is where i had my read: http://www.mail-archive.com/web2py@googlegroups.com/msg31506.html [web2py] storing a Python list Carl Wed, 17 Feb 2010 07:47:16 -0800 not sure either yet on the web2py detailed implementation (i.e the use of text_factory?), but looking forward to taking that in. hope it helps, Mart:) On Aug 17, 6:48 pm, apaterno <apate...@gmail.com> wrote: > Yes, In fact I'm doing some like that but I was just wondering if > there's some "web2py" way of doing It, > > On Aug 17, 5:20 pm, mart <msenecal...@gmail.com> wrote: > > > 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