recordset from multiple checkbox values

Expand Post »

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)

Similar Threads

get checkbox value in PHP
Insert multiple checkbox values of array into mysql db in PHP
checkbox values calculation with PHP in PHP
problem in passing multiple checkbox values in ASP
checkbox values in JSP

william_stam

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

131 posts
since Mar 2005

Permalink

Mar 21st, 2005

Re: recordset from multiple checkbox values

Give your checkboxes the same name.

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

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)

hollystyles

Reputation Points: 262

Solved Threads: 68

Veteran Poster

Offline

1,181 posts
since Feb 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: check box

Next Thread in ASP Forum Timeline: repeat region into declared variable (jmail body)

DaniWeb Message

Cancel Changes

User Name
Password