That makes sense. So, what I would like is either a comma sepparated list in the column, or space separated. aperson bperson cperson The end result is this... I would like to create an array, at a later time, based on this record, to generate a view in html of the selected items and also to create a mailto: link from these. These are usernames on our network, so I can simply add the '@domain.com' and I am set. My thought was this... (simplified, of course) <dtml-in sqlMethod> <dtml-var Column1> <dtml-var Column2> <dtml-var Column3> <dtml-in PeopleInvolved> <a href="mailto:<dtml-var sequence-item>@domain.com">Email: <dtml-var sequence-item></a> </dtml-in> </dtml-in> Storing the multiple values in this way should work, correct? But, how do I get them to store that way? Greg -----Original Message----- From: Thomas B. Passin [mailto:tpassin@mitretek.org] Sent: Tuesday, September 03, 2002 12:40 PM To: zope@zope.org Subject: Re: [Zope] lists, not strings in database [Greg Fischer] [[ I need help with saving a select box value. When multiple items are selected in my form, and then inserted into a SQL server, it is saved as a string that looks like a list. I have tried to specify the data type in name value, none of which change the stored value in the database. ]] First you have to decide what should be stored in the database when the form has multiple selections. Then you have to decide how to insert that into the database. Then we can talk about how to make Zope do that, if it has not become clear by then. Cheers, Tom P _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )