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