Trouble handling checkboxes

[PushCode]

My form page has some dynamically listed checkboxes, all with the same name. I'm trying to insert any values that are checked into a SQL db. The problem is that it is only inserting the first of the checked boxes gets inserted. I don't get any errors.

Here's my checkbox code:

response.write  cellstart & "<input type=""checkbox"" name=""opt"" value="""& opt_id &""" />" & opt_name & "</td>"

Here's the relevent action page code:

opt = Request.Form("opt")
aryopt = Split(opt, ",")
set con = server.createObject("ADODB.Connection")
con.open(strServerConnection)
'insert options
For x = 0 to Ubound(aryopt)
	Dim sqlOpt
	sqlOpt = "INSERT INTO ecom_option_match (prod_id, opt_id) VALUES ('"&prod_id&"', '"&aryopt(x)&"')"
	con.execute(sqlOpt)
Next

Any ideas as to why it's only inserting the first checked value?

Thanks!

 

[monksnake]

Are you looping your code that response.write(s) the checkboxes??

If not, you will only have one checkbox show

<.

 

[PushCode]

Yes I'm looping that code. The form page is working fine. All the checkboxes show up as expected.

 

[PushCode]

Nevermind, figured it out.