recordset from multiple checkbox values
 

I have a page that displays the records from the database (repeated down) if the user selects (checkbox) a few records and clicks submit it passes the value (dbase record ID) to another page that retrieves the value and builds another recordset with just the records selected from the first page. :?: :?: :?:

The webmail pages make use of this (ie: select a few e-mails and click "trash" and those e-mails get deleted)

Re: recordset from multiple checkbox values
 

Give your checkboxes the same name.

<input type="checkbox" name="mycheckbox" value="1">

<input type="checkbox" name="mycheckbox" value="2">

.

.

.

n

Then when the form is posted you have an array which you can iterate or pass to a stored procedure or whatever your prefered method is.

sql="update table set column=value where id in ("



for i = 0 to Request.Form("mycheckbox").length - 1

        if i=0 then

            sql=sql & Request.Form("mycheckbox").item(i)

        else

            sql=sql & "," & Request.Form("mycheckbox").item(i) 

        end if

next



sql = sql & ")"



con.execute(sql)