I am hand-coding (no FrontPage or DreamWeaver) an ASP, VBScript, MS Access 2000 dynamic web site.

Does anyone know how to take selected item(s) from a multi-select drop-down box in a form and insert them into the database?

The syntax looks tricky and I cannot seem to get it right.

For instance- drop down offers 5 choices. User picks 3. What is EXACT syntax for INSERT of all 3 items into database?

Also-having trouble with INSERT and apostrophes in user-entered fields (ex: Max's Deli gives me an error), but I don't want to tell users to avoid apostrophes.

Also-if anyone knows how I can gather user ratings and calculate averages of them, I would be very grateful.

Thanks so much