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"
If request("Cancel2"
If request("Cancel3"
cancelSQL = "Delete FROM reserve WHERE ((reserve.RID)='"& Cancel1 &"') OR ((reserve.RID)='"& Cancel2 &"') OR ((reserve.RID)='"& Cancel3 &"')"
DBConn.Execute (cancelSQL)
end if