•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 391,593 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,665 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 6157 | Replies: 6
 |
•
•
Join Date: Jul 2005
Posts: 41
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
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.
what's wrong with my code? how come only 1 checkbox is checked when there should be 2 checked checkboxes?
THANKS.
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.
<%
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
%> THANKS.
cheers,
ohgosh
ohgosh
•
•
Join Date: May 2005
Posts: 494
Reputation:
Rep Power: 4
Solved Threads: 18
Posting Pro in Training
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 ?
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 ?
•
•
Join Date: Jul 2005
Posts: 41
Reputation:
Rep Power: 4
Solved Threads: 0
Light Poster
so how should i do? any improvement on d code u could provide in here? sorry to bother u..
what do u mean? could u explain furthermore? thanks~
•
•
•
•
So you need to dynamically rename these boxes.
what do u mean? could u explain furthermore? thanks~
cheers,
ohgosh
ohgosh
•
•
Join Date: May 2005
Posts: 494
Reputation:
Rep Power: 4
Solved Threads: 18
Posting Pro in Training
•
•
•
•
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.
what's wrong with my code? how come only 1 checkbox is checked when there should be 2 checked checkboxes?<% 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 %>
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?
•
•
Join Date: Jul 2005
Posts: 41
Reputation:
Rep Power: 4
Solved Threads: 0
Light Poster
do u mean this:
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,
it gave me this:
Admin Admin
Admin Student
Admin Parent
Admin Teacher
Admin Principal
how and what should i do?
<%
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,
<%response.Write(rsView("userType") & rsUser("userType"))%>Admin Admin
Admin Student
Admin Parent
Admin Teacher
Admin Principal
how and what should i do?
cheers,
ohgosh
ohgosh
•
•
Join Date: Mar 2005
Location: LTT, South Africa
Posts: 125
Reputation:
Rep Power: 4
Solved Threads: 1
Junior Poster
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?
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:
Rep Power: 4
Solved Threads: 0
Light Poster
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
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
<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
cheers,
ohgosh
ohgosh
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
Linear Mode
- MySQL Checkbox Multiple data Delete? (PHP)
- PHP Checkbox (PHP)
- asp:repeater in a form? (ASP.NET)
- get checkbox value (PHP)
- Help! Mail inbox is locked - how can I unlock it? (Mac Software)
- checkbox values calculation with PHP (PHP)
- grouping unique name in table (MS SQL)
- a weird Javascript error (JavaScript / DHTML / AJAX)
Other Threads in the ASP Forum
- Previous Thread: how do i get the current time when i click a button?
- Next Thread: help need for dropdownlist
