webForumDet fria alternativet

Hjälp med felmeddelane!

ASP

4 svar · 223 visningar · startad av Saurus

Medlem sedan okt. 20015 inlägg
Frågan#1

Felmeddelandet:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/gorza112/forum/postForm.asp, line 40

Koden:

<%
Dim objConn
Dim strConn
Dim strSQL
Dim lngThreadParent
Dim strThreadPoster
Dim strThreadName
Dim strThreadPosterEmail
Dim strThreadHeadline
Dim strThreadText
Dim dtmThreatDateTime
Dim strDummy

strDummy = "Ingen angiven"

lngThreadParent = Request.Form("threadParent")

if lngThreadParent = "" then lngThreadParent = 0

strThreadPoster = Replace(Request.Form("threadPoster"), "'", "''")
strThreadPosterEmail = Replace(Request.Form("threadPosterEmail"), "'", "''")
strThreadHeadline = Replace(Request.Form("threadHeadline"), "'", "''")
strThreadText = Replace(Request.Form("threadText"), "'", "''")
dtmThreatDateTime = Now()

if strThreadName = "" then strThreadName = strDummy
if strThreadPosterEmail = "" then strThreadPosterEmail = strDummy
if strThreadHeadline = "" then strThreadHeadline = strDummy
if strThreadText = "" then strThreadText = strDummy

Set objConn = Server.CreateObject("ADODB.Connection")

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/forum.mdb")
objConn.Open strConn

strSQL = "INSERT INTO tblForum (threadDateTime, threadPoster, threadPosterEmail, threadHeadline, threadText, threadParent) VALUES('" & dtmThreatDateTime & "', '" & strThreadPoster & "', '" & strThreadPosterEmail & "', '" & strThreadHeadline & "', '" & strThreadText & "', " & lngThreadParent & ")"

objConn.Execute(strSQL)

objConn.Close
Set objConn = nothing

Response.Redirect("default.asp")
%>

Medlem sedan feb. 200112 078 inlägg
#2

Har du skrivrättigheter i mappen?

Medlem sedan nov. 2002544 inlägg
#3

lalala ångrade mig

Medlem sedan okt. 20015 inlägg
#4

Det var min kompis som hade problem :P

Medlem sedan feb. 200112 078 inlägg
#5

Ordnade det sig?

253 ms totalt · 4 externa anrop · v20260731065814-full.86ec41c2
122 ms — deklarationer (db)
0 ms — hämta statistik (cache)
126 ms — hämta tråd, inlägg och bilagor (db)
121 ms — ändringar (db)