DaniWeb Forum Index > Web Development > ASP

ASP RSS

recordset from multiple checkbox values

Please support our ASP advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Mar 2005

Posts: 131

Reputation: william_stam is an unknown quantity at this point

Solved Threads: 2

william_stam william_stam is offline

Offline

Junior Poster

recordset from multiple checkbox values

Mar 10th, 2005

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)

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: recordset from multiple checkbox values

Mar 21st, 2005

Give your checkboxes the same name.

Help with Code Tags

(Toggle Plain Text)

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

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
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)
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)