I have a list of records in the database on one of my pages. I have it setup, were you have to delete each record manually. I would like to add a checkbox beside the records, and a button to delete checked items, but when I set it up, when I checked some of the records the code I was using only delted the first record that I checked. Here is the code that I used:
<%
ScoreID=Request.QueryString("ScoreID")
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("Quiz.mdb")
rs = "DELETE * FROM Scores WHERE ScoreID= " & ScoreID & ";"
conn.execute rs
conn.close
set conn=nothing
%>
Please Help!