En sql-insert fejl
HejBruger koden:
strSQL = "Insert into ind-news (emne, navn, telefon, mail, tekst, ip)"
strSQL = strSQL & " values('" & replace(request.form("emne"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("navn"),"'","''") & "', "
strSQL = strSQL & replace(request.form("telefon"),"'","''") & ", "
strSQL = strSQL & "'" & replace(request.form("mail"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("tekst"),"'","''") & "', "
strSQL = strSQL & "'" & request.ServerVariables("REMOTE_ADDR") & "')"
Conn.Execute(strSQL)
Får fejlen:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
SQL-Sætning:
Insert into ind-news (emne, navn, telefon, mail, tekst, ip) values('En test', 'Mads Jensen', 22892128, 'test@test.dk', 'En dejlig lille test', '**.**.**.**')
Help me!
Lange
