Have the script keep a count of the number of records you loop through to create the records and the checkboxes. Use the current count for part of the name for each row's checkbox. Also have a hidden field named based off the current count whose value is the unique id of the record that the row represents. Like id1,id2,id3 and cb1,cb2,cb3. Have a hidden field at the end of the form that tells how many "rows" there are total.
i = 1
do while (orset.eof = false)
response.write "<input type=""hidden"" name=""id" & i & """ value=""" & orset.fields("id") & """ />"
response.write "<input type=""checkbox"" name=""cb" & i & """/>"
response.write "<br />"
i = i+1
orset.movenext
next
response.write "<br />"
response.write "<input type=""hidden"" name=""totalCount"" value=""" & i & """ />"
Now do this when they submit
get the total from your hidden field at the end of the form. Loop from the first number until the total. Your script will probably look like this...
totalCount = request.form("totalCount")
for i=1 to totalCount
if (request.form("cb" & i) = "on") then
sql="DELETE * FROM myTable WHERE [id]=" & request.form("id" & i) & " AND [issued]=false;"
conn.execute(sql)
end if
next
If issued is false, that means it wasn't issued. So even if the query finds the id, the id must also be pending. Otherwise it is ignored.
You'll probably end up doing as many SQL deletes as there are records on a page. So i'd keep pages small. I haven't had a chance to test if the code itself is good, but the idea does work and it is how I create my dynamic forms this way.
Hopes this helps.