I have to be able to update a checkbox and I am not sure why it is not working. I'll paste the code that generates the checkboxes as well as the code that I am using to update the checkbox
this code is what i am using to update the checkboxes....
set rsOption=server.CreateObject("ADODB.Recordset")
rsOption.Open "SELECT * FROM used_car_options WHERE CarID = 0",dbData,1,3
for a = 1 to Request.Form("description").Count
rsOption.AddNew
rsOption.Fields("CarID")=rsListing.Fields("CarID")
rsOption.Fields("OptionID")=Request.Form("description").Item(i)
rsOption.Update
next
rsOption.Close
set rsOption=nothing
this is the code that generates the checkboxes
<%If Not(rsOptions.EOF AND rsOptions.BOF) Then rsOptions.MoveFirst
numincol = rsOptions.recordcount \3+1
Do Until rsOptions.EOF%>
<td valign="top">
<%for i = 1 to numincol
If rsOptions.EOF Then Exit For%>
<input type="checkbox" name="<%=rsOptions.Fields("Description")%>" value="<%=rsOptions.Fields("ID")%>" <%If rsOptions.Fields("Exist") <> vbNullString Then Response.Write " checked"%>>
<%=rsOptions.Fields("Description")%><br>
<%rsOptions.MoveNext
Next%>
</td>
<%Loop%>
I have declared rsOptions to create the checkboxes
i for the counter in relation to the checkboxes
rsOption to create the recordset that is to be modified and finally a to count through the list. Where am I making my mistake?
