guys plz help, my delete code doesn't work.i have a delete button on the message display board, whereby a msg is supposed to be deleted on the click of the button.Any suggestions??here's my code
Dim Conn, ConnString
set ConnString = server.createobject("adodb.connection")
conn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("forum1.mdb")&";"
'Create the Connection object
connString.open (conn)
if request("action") = "delete" then
sql = "DELETE* FROM messages WHERE id = '" & request("id")&"'"
Connstring.execute(sql)
Response.Write("<h1>The message has been deleted.</font><br>Back to <a href='forumlist.asp'>Forum</h1>")
Connstring.Close
end if
%>