Multiple checkbox select sample

  Select a bunch of the checkbox’s and then click submit List of all parents in database, those that are enabled are checked.

Select a bunch of the checkbox’s and then click submit

List of all parents in database, those that are enabled are checked.

BMW
Chevy
Ford
GMC
Mustang
Truck
Family
Van
Semi


Here is the code for this Example

Page one the input

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME=”GENERATOR” Content=”Microsoft Visual Studio 6.0″>
</HEAD>
<title>Multiple checkbox select sample</title>
<BODY>
<!– Author: Adrian Forbes –>
<%
strconn = “Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;
PWD=Password;DATABASE=Database_Name
set conn = server.createobject(“adodb.connection”)
conn.open strconn
set objRS = createobject(“ADODB.Recordset”)
objRS.Open “select ID, strParent, bitEnabled from Parents”, strconn
%>
<p>
List of all parents in database, those that are enabled are checked.
</p>
<form name=frmTest action=”MultipleCheckboxesTarget.asp” method=POST>
<%
iCount = 0
while not objRS.EOF
    lID = clng(objRS(“ID”))
    iCount = iCount + 1%>
<input type=CHECKBOX name=chkParent<%=iCount%> value=”<%=objRS(“ID”)%>”<%if objRS(“bitEnabled”) then Response.Write ” CHECKED” end if%>><%=objRS(“strParent”)%><br>
<%    objRS.MoveNext
wend
objRS.Close
set objRS.ActiveConnection = nothing
set objRS = nothing
%>
<input type=HIDDEN name=txtCount value=”<%=iCount%>”>
<p><input type=SUBMIT value=”Select”></p>
</form>
</BODY>
</HTML>

Page 2. Shows the Results of what was selected

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME=”GENERATOR” Content=”Microsoft Visual Studio 6.0″>
<title>Checkbox selection</title>
</HEAD>
<BODY>
<!– Author: Adrian Forbes –>
<%
iCount = Request(“txtCount”)
%>
<p>
There were <%=iCount%> checkboxes
</p>
<p>
<%
for i = 1 to iCount
    sID = Request(“chkParent” & i)
    if sID = “” then
        Response.Write “Item ” & i & ” was NOT checked<br>”
    else
        Response.Write “Item ” & i & ” was checked, it’s ID is ” & sID & “<br>”
    end if
next
%>
</p>
</BODY>
</HTML>

One thought on “Multiple checkbox select sample

[gp-comments width="770" linklove="off" ]