I have a multiple select box in a form. I know that when this is submitted, it producers a string with all the selected values separated by commas. What I need to do is beable to take that string, no matter how many values it has, and insert a new row in to my table for each comma delimited item. (I am useing ASP classic and SQL Server 2000.) Here is a quick example of what I need:
1. User selects Widget A, Widget B, and Widget C from the select box and hits submit.
2. A string is passed to the next page that equals "Widget A, Widget B, Widget C"
3. I need to insert 3 new records into my SQL table, one for each item.
Of course, in my real world example, the user can, and most likely will, select a couple hundred items at once.
Any help in this matter would be greatly appreciated.