DaniWeb Forum Index > Web Development > ASP

how do i get more than one checkbox being checked

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

how do i get more than one checkbox being checked

Aug 22nd, 2005

HI there,

i haf a series of dynamic checkbox retrieved from db. I can display my checkbox successfully but now i cant get more than one checkbox being checked.

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%
     sqlUser= "select distinct * from t_user_type order by userType"
     set rsUser = conn.execute(sqlUser)
 
     do while not rsUser.eof
 
     sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType"
     set rsView = conn.execute(sqlView)
%>
 
<tr>
     <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>
<%
     rsUser.moveNext
     loop
%>
<%
     sqlUser= "select distinct * from t_user_type order by userType"
     set rsUser = conn.execute(sqlUser)
		
     do while not rsUser.eof
		
     sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType"
     set rsView = conn.execute(sqlView)
%>

<tr>
     <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>
<%
     rsUser.moveNext
     loop
%>

what's wrong with my code? how come only 1 checkbox is checked when there should be 2 checked checkboxes?

THANKS.

cheers,
ohgosh

•

Join Date: May 2005

Posts: 514

Reputation: techniner is an unknown quantity at this point

Solved Threads: 19

techniner

Offline

Posting Pro

Re: how do i get more than one checkbox being checked

Aug 23rd, 2005

The problem is they have the same NAME

Your telling it

<input name="deleted" <--- So it loops through

So you need to dynamically rename these boxes.

maybe increment the variable like +1 and walk the loop giving each input a different name ?

Did my post help?

Visit Little Jon's Web Portal
Utilize Jon Coiro's Tech Support Remote Services
Need to Increase Your Traffic?

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

Re: how do i get more than one checkbox being checked

Aug 23rd, 2005

so how should i do? any improvement on d code u could provide in here? sorry to bother u..

•

So you need to dynamically rename these boxes.

what do u mean? could u explain furthermore? thanks~

cheers,
ohgosh

•

Join Date: May 2005

Posts: 514

Reputation: techniner is an unknown quantity at this point

Solved Threads: 19

techniner

Offline

Posting Pro

Re: how do i get more than one checkbox being checked

Aug 23rd, 2005

•

Originally Posted by ohgosh

HI there,

i haf a series of dynamic checkbox retrieved from db. I can display my checkbox successfully but now i cant get more than one checkbox being checked.
Help with Code Tags

ASP Syntax (Toggle Plain Text)
<%
     sqlUser= "select distinct * from t_user_type order by userType"
     set rsUser = conn.execute(sqlUser)
 
     do while not rsUser.eof
 
     sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType"
     set rsView = conn.execute(sqlView)
%>
 
<tr>
     <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>
<%
     rsUser.moveNext
     loop
%>
<% sqlUser= "select distinct * from t_user_type order by userType" set rsUser = conn.execute(sqlUser) do while not rsUser.eof sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType" set rsView = conn.execute(sqlView) %> <tr> <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td> </tr> <% rsUser.moveNext loop %>
what's wrong with my code? how come only 1 checkbox is checked when there should be 2 checked checkboxes?
THANKS.

Well Do something like this

varcount=0

inside the loop do
varcount= varcount+1
namevar=deleted+varcount

<td><input name="& namevar &" blah blabvh

You follow?

Did my post help?

Visit Little Jon's Web Portal
Utilize Jon Coiro's Tech Support Remote Services
Need to Increase Your Traffic?

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

Re: how do i get more than one checkbox being checked

Aug 23rd, 2005

do u mean this:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%
     i = 0
     varcount = 0
     sqlUser= "select * from t_user_type order by userType"
     set rsUser = conn.execute(sqlUser)
 
     do while not rsUser.eof
     i = i + 1
     varcount = varcount + 1
     deleted = deleted + varcount
 
     sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType"
     set rsView = conn.execute(sqlView)
%>
 
<tr>
     <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>
<%
     rsUser.moveNext
     loop
%>
<%
     i = 0
     varcount = 0
     sqlUser= "select * from t_user_type order by userType"
     set rsUser = conn.execute(sqlUser)
		
     do while not rsUser.eof
     i = i + 1
     varcount = varcount + 1
     deleted = deleted + varcount
	
     sqlView = "select * from t_email_view where emailID = '" & emailID & "' and emailView = '1' order by userType"
     set rsView = conn.execute(sqlView)
%>

<tr>
     <td><input name="deleted" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>
<%
     rsUser.moveNext
     loop
%>

nothing happens, it is still the same..

i think something's wrong with my checking of checked checkboxes statement. it doesn't seem to loop thru the rsView("userType").

when i do a response.write in the <td> tag,

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%response.Write(rsView("userType") & rsUser("userType"))%>
<%response.Write(rsView("userType") & rsUser("userType"))%>

it gave me this:

Admin Admin
Admin Student
Admin Parent
Admin Teacher
Admin Principal

how and what should i do?

cheers,
ohgosh

•

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

Re: how do i get more than one checkbox being checked

Aug 24th, 2005

im seriously not following. where does the checkboxes come into it?

what do you hope to achieve???

you might want to change the name of the checkbox

if you pass it like that it would come out as ?deleted=1,2,3,4,5. which unless you right a split routine it wont help you.

<tr>
<td><input name="<%=deleted%>" type="checkbox" value="<%=rsUser("userType")%>" <%if rsView("userType")=rsUser("userType") then response.Write(" checked")%> ><%=rsUser("userDesc")%></td>
</tr>

surely there should be an endif there?

•

Join Date: Jul 2005

Posts: 41

Reputation: ohgosh is an unknown quantity at this point

Solved Threads: 0

ohgosh

Offline

Light Poster

Re: how do i get more than one checkbox being checked

Aug 29th, 2005

heiya.. thanks william_stam!! saw so many of your replies & am grateful.. seems that you're quite pro in programmin ar?

anyw.. i use diff way to store my checkbox n the checking of the checkboxes by hard coding them and not retrieving frm db anymore.. i still have a Qn.. how do i validate them? validate to check that one of the checkbox must be checked in order to save the changes in the current page.

here are my checkbox codings

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<input type="checkbox" name="stud" value="yes">Student
<input type="checkbox" name="lect" value="yes">Lecturer
<input type="checkbox" name="principal" value="yes">Principal 
<input type="checkbox" name="admin" value="yes">Administrator 
<input type="checkbox" name="parent" value="yes">Parent
<input type="checkbox" name="stud" value="yes">Student
<input type="checkbox" name="lect" value="yes">Lecturer
<input type="checkbox" name="principal" value="yes">Principal 
<input type="checkbox" name="admin" value="yes">Administrator 
<input type="checkbox" name="parent" value="yes">Parent