n4narik
asked on
Changing boolean values in a database using checkboxes.
I have a SQL2000 DB with a table about 'builders'. It has three fields: ID, Name, IsActive. IsActive is a boolean field. I would like to display the contents of the table with check-boxes for IsActive column in a web-page. When I check or uncheck the check-boxes, the values in the DB should change after I click a submit button.
This a piece of code I used to simply display the contents:
<div align=center>
<table border=1 cellspacing=0 cellpadding=2><tr>
<td align=center><b>Builder ID</b></td>
<td align=center><b>Name</b></
<td align=center><b>Active?</b
<%
do until rs.EOF
%>
<tr>
<td><%=rs(0)%></td>
<td><%=rs(1)%></td>
<td><%=rs(4)%></td>
</tr>
<%
rs.movenext
loop
%>
</table></div>
This a piece of code I used to simply display the contents:
<div align=center>
<table border=1 cellspacing=0 cellpadding=2><tr>
<td align=center><b>Builder ID</b></td>
<td align=center><b>Name</b></
<td align=center><b>Active?</b
<%
do until rs.EOF
%>
<tr>
<td><%=rs(0)%></td>
<td><%=rs(1)%></td>
<td><%=rs(4)%></td>
</tr>
<%
rs.movenext
loop
%>
</table></div>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
:) thanks....to do that you wil have to do a split
thanks n4narik nice to help you!
ASKER