<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]