<form method=post>
<select multiple size=5 name=ItemID>
<option value=1>Item 1</option>
<option value=2>Item 2</option>
<option value=3>Item 3</option>
<option value=4>Item 4</option>
</select>
</form>


--------

<%
ItemID = Request.Form("ItemID")
arrItemID = Split(ItemID, ", ")

For Each x In arrItemID
    Set objRS = objConn.Execute("INSERT INTO tblTable (ItemID) VALUES ("& x
&")")
    Set objRS = Nothing
Next
%>

HTH
Sam



----- Original Message -----
From: "Adam" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 2:40 PM
Subject: using select box to make multiple selections


> Hi,
>
> I have a select box with a bunch of options.  I need to allow my visitors
to
> select multiple options from one select box, then insert them into a
> database.  Does anyone know how i could achieve this?  I guess i would
need
> to make an array, but arrays always confuse me.
>
> Thanks in advance for any help,
>
> Adam
>
>
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
>


---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to