var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: insert problems: apostrophes and multi-select dropdown items
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