i wan to loop through every checkbox and able to delete as many check box that are checked. but the code shown only limit to 3 checkbox. how can i delete all the checked box?
if cancel = "Delete" then
If request("Cancel1" = "" then Cancel1 = 0 else Cancel1 = request("Cancel1"end if
If request("Cancel2" = "" then Cancel2 = 0 else Cancel2 = request("Cancel2"end if
If request("Cancel3" = "" then Cancel3 = 0 else Cancel3 = request("Cancel3"end if
cancelSQL = "Delete FROM reserve WHERE ((reserve.RID)='"& Cancel1 &"') OR ((reserve.RID)='"& Cancel2 &"') OR ((reserve.RID)='"& Cancel3 &"')"
DBConn.Execute (cancelSQL)
end if
if cancel = "Delete" then
If request("Cancel1" = "" then Cancel1 = 0 else Cancel1 = request("Cancel1"end if
If request("Cancel2" = "" then Cancel2 = 0 else Cancel2 = request("Cancel2"end if
If request("Cancel3" = "" then Cancel3 = 0 else Cancel3 = request("Cancel3"end if
cancelSQL = "Delete FROM reserve WHERE ((reserve.RID)='"& Cancel1 &"') OR ((reserve.RID)='"& Cancel2 &"') OR ((reserve.RID)='"& Cancel3 &"')"
DBConn.Execute (cancelSQL)
end if