[pnqoma]

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
%>

[Shane]

Originally Posted by pnqoma

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
%>

In your DB, what data type if your ID column?

[Stealth]

you dont need DELETE * FROM just DELETE FROM