Så er den gal igen... Syntaxt error i sql-streng til access
Hey igen (http://www.eksperten.dk/spm/345041)!Følgende kode giver stadig mange fejl:
If Request("nyhedsbrev") = "on" then
strSQL3 = "INSERT INTO email (email,date,ip)"
strSQL3 = strSQL3 & " VALUES("
strSQL3 = strSQL3 & "'" & str_email & "',"
strSQL3 = strSQL3 & "'" & Now & "',"
strSQL3 = strSQL3 & "'" & Request.ServerVariables("REMOTE_ADDR") & "'"
strSQL3 = strSQL3 & ")"
Response.Write "strSQL3 = " & strSQL3 & "<BR>"
conn.execute(strSQL3)
End if
----------------------
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/vin/checkout.asp, line 107
Linie 107: conn.execute(strSQL3)
U know what to do! ;=)
