Question about multiple selection list

[sheilat]

I can choose more than one item in my list by using the control key and then clicking on the items. The data is successfully stored in the SQL database separated by commas.  If I then want to display the data to the user in the same list format, it doesn't highlight the selected items. I can of course show the selections in a text box, but that defeats the purpose of the list display since I would like users to be able to make changes to the list - and then do an update for example.  Any suggestions? Is this supposed to work?

[David_Powers]

Which server-side language are you using?

[sheilat]

I am using asp files with VB script - but so far have only used dreamweaver tools from the design interface. Do I need to create my own vb script to do this? if so, can you please give me a hint as to how to do it.  Thanks

[David_Powers]

If it were PHP, I could help, but my knowledge of ASP is minimal.

Dreamweaver server behaviors can't do this for you. Basically, what you need to do is this:

• The result from your database will be a comma-separated string containing the selected values.
• You need to split that string into an array of individual values.
  
• For each <option> tag, you check the values in the array against the current value. If there's a match, you insert selected="selected" into the <option> tag.

[sheilat]

Hi David,

Thank you very much for describing the solution. I have a tiny bit of experience with asp coding and will try to implement your suggestion.