500 server fejl.....
Jeg har dette script:<%
response.buffer = True
%>
<%
'Set Conn = Server.CreateObject("ADODB.Connection")
'Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("scart.mdb")
'SQLstmt = "DELETE * FROM products WHERE catalogID = ' & request("catalogID")'"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MSDASQL;" & "DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & server.mappath("scart.mdb")
SQL = "DELETE * FROM products WHERE catalogID = " & Request("id")
set RS = conn.execute(SQL)
Rs.close
Set Rs= Nothing
Conn.Close
set Conn=nothing
response.redirect ("ret.asp?id=" & request.form("skod") & "")
%>
Det sletter fint med det redirecter ikke! Den kommer bare med en 500 server fejl (HTTP 500 - Intern serverfejl ) Hvad er der galt???
