Hvordan undgår jeg dene fejlmeddelse
har lavet en nyheds ting på et website..men jeg for hele tiden denne fejl medelelse..Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''well now it's up just a needa few things'.
/pubnews.asp, line 23
------
min kode
Submit formen.:
response.write besked
response.write "<form action='pubnews.asp' method='post'>"
response.write "<table border='0' cellspacing='0' class='" & farve & "'>"
response.write "<tr><td><b>" & "Headline.:" & "</b></td><td>" & "<input type='text' name='pheadline' size='50'>" & "</td></tr>"
response.write "<tr><td><b>" & "News.:" & "</b></td><td>" & "<textarea name='pnews' rows='10' cols='50'>" & "</textarea>" & "</td></tr>"
response.write "<tr><td>" & "<input type='submit' value='Update'>" & "</td></tr>"
response.write "</table>"
response.write "</form>"
her prøver jeg at ligge det i db'en.:
response.buffer = true
if request.form <> "" then
pheadline = request.form("pheadline")
pnews = request.form("pnews")
Dato = formatdatetime(now, VBshortdate) & " " & formatdatetime(now, VBshorttime)
Set ObjConn = Server.createobject("ADODB.Connection")
ObjConn.open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=" & server.mappath("../database/indhold.mdb")
newsSQL = "INSERT INTO news ( "
newsSQL = newsSQL & "Pubhead, "
newsSQL = newsSQL & "Pubnews, "
newsSQL = newsSQL & "Dat) "
newsSQL = newsSQL & "values ( "
newsSQL = newsSQL & "'" & pheadline & "', "
newsSQL = newsSQL & "'" & pnews & "', "
newsSQL = newsSQL & "'" & dato & "') "
response.write newssql
ObjConn.execute(newsSQL)
'Objconn.close
'Set ObjConn = Nothing
response.redirect "forside.asp?id=22" & "&menuID=4" & "&UmenuID=22" & "&besked=6"
hheeelp please :)
