Problem med SQL....
sAuthor = session("login")sTopic = Trim (Request.Form ("topic"))
sText = Trim (Request.Form ("text"))
sDate = Date
sTopic = Replace (sTopic, "'", "''")
sText = Replace (sText, "'", "''")
sSQL = "INSERT INTO news (author,topic,text,date) VALUES ('" & sAuthor & "','" & sTopic & "','" & sText & "',#" & sDate & "#)"
oConn.Execute (sSQL)
giver fejl:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/cold/addTxt.asp, line 24
