14. maj 2001 - 04:11
Der er
1 kommentar og 1 løsning
Hvorfor virker dette ikke??
<html> <head> <title></title> </head> <body> <% Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"sirigrt.mdb\") SQLstmt = \"UPDATE DISTINCTROW undersider SET link = \'\" & request.form(\"link\") & \"\', venstre = \'\" & request.form(\"venstre\") & \"\', venstrehead = \'\" & request.form(\"venstrehead\") & \"\', venstremidthead = \'\" & request.form(\"venstremidthead\") & \"\', venstremidt = \'\" & request.form(\"venstremidt\") & \"\', venstrenedhead = \'\" & request.form(\"venstrenedhead\") & \"\', venstrened = \'\" & request.form(\"venstrened\") & \"\', hojrehead = \'\" & request.form(\"hojrehead\") & \"\', hojre = \'\" & request.form(\"hojre\") & \"\', hojremidthead = \'\" & request.form(\"hojremidthead\") & \"\',hojremidt = \'\" & request.form(\"hojremidt\") & \"\', hojrenedhead = \'\" & request.form(\"hojrenedhead\") & \"\',hojrened = \'\" & request.form(\"hojrened\") & \"\' WHERE id = \" & Request(\"id\") response.write sqlstmt Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing response.redirect (\"ahap.asp\") %> </body> </html>
Annonceindlæg fra Cognizant
Du behøver ikke alt dit Html Det jeg tror er galt, er at du har \"glemt\" response.buffer = true , men det er meget smart at give en fejl meddelse med når man stiller sådan et spørgsmål! <% response.buffer = true Set Conn = Server.CreateObject(\"ADODB.Connection\") Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"sirigrt.mdb\") SQLstmt = \"UPDATE DISTINCTROW undersider SET link = \'\" & request.form(\"link\") & \"\', venstre = \'\" & request.form(\"venstre\") & \"\', venstrehead = \'\" & request.form(\"venstrehead\") & \"\', venstremidthead = \'\" & request.form(\"venstremidthead\") & \"\', venstremidt = \'\" & request.form(\"venstremidt\") & \"\', venstrenedhead = \'\" & request.form(\"venstrenedhead\") & \"\', venstrened = \'\" & request.form(\"venstrened\") & \"\', hojrehead = \'\" & request.form(\"hojrehead\") & \"\', hojre = \'\" & request.form(\"hojre\") & \"\', hojremidthead = \'\" & request.form(\"hojremidthead\") & \"\',hojremidt = \'\" & request.form(\"hojremidt\") & \"\', hojrenedhead = \'\" & request.form(\"hojrenedhead\") & \"\',hojrened = \'\" & request.form(\"hojrened\") & \"\' WHERE id = \" & Request(\"id\") response.write sqlstmt Conn.Execute (SQLstmt) conn.Close Set conn = nothing Set SQLstmt = nothing response.redirect (\"ahap.asp\") %>