Ad:

ASP Discussion Thread
Unsolved
Views: 8815

Aug 22nd, 2005

how do i get more than one checkbox being checked

Expand Post »

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.

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.

Similar Threads

MySQL Checkbox Multiple data Delete? in PHP
get checkbox value in PHP
checkbox values calculation with PHP in PHP
PHP Checkbox in PHP
asp:repeater in a form? in ASP.NET

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 2005

Permalink

Aug 23rd, 2005

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

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 ?

techniner

Reputation Points: 12

Solved Threads: 19

Posting Pro

Offline

521 posts
since May 2005

Permalink

Aug 23rd, 2005

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

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

Quote ...

So you need to dynamically rename these boxes.

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

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 2005

Permalink

Aug 23rd, 2005

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

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

techniner

Reputation Points: 12

Solved Threads: 19

Posting Pro

Offline

521 posts
since May 2005

Permalink

Aug 23rd, 2005

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

do u mean this:

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,

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?

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 2005

Permalink

Aug 24th, 2005

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

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?

william_stam

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

131 posts
since Mar 2005

Permalink

Aug 29th, 2005

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

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

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

ohgosh

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

41 posts
since Jul 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: how do i get the current time when i click a button?

Next Thread in ASP Forum Timeline: help need for dropdownlist

DaniWeb Message

Cancel Changes

User Name
Password