Fejl i SQL?
Jeg får følgende fejl ved nedenstående SQL:INSERT INTO invoice (userid,name,address,zipcode,city,country,date,paymentId,sessionId) VALUES ('1','Per Jørgensen','Gyngevej 17','8520','Århus','Danmark','20-03-2002','4','38238344')
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e14'
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen.
/emb.dk/www/includes/inc_global.asp, line 21
Selve SQL'en ser sådan ud:
strSQLInvoice = "INSERT INTO invoice "
strSQLInvoice = strSQLInvoice & "(userid,name,address,zipcode,city,country,date,paymentId,sessionId) VALUES ("
strSQLInvoice = strSQLInvoice & "'" & Session("UserId") & "',"
strSQLInvoice = strSQLInvoice & "'" & RS("name") & "',"
strSQLInvoice = strSQLInvoice & "'" & RS("address") & "',"
strSQLInvoice = strSQLInvoice & "'" & RS("zipcode") & "',"
strSQLInvoice = strSQLInvoice & "'" & RS("city") & "',"
strSQLInvoice = strSQLInvoice & "'" & RS("country") & "',"
strSQLInvoice = strSQLInvoice & "'" & Date() & "',"
strSQLInvoice = strSQLInvoice & "'" & Request.Querystring("payment") & "',"
strSQLInvoice = strSQLInvoice & "'" & Session.SessionId & "'"
strSQLInvoice = strSQLInvoice & ")"
