SQL Syntax error! Help!!!!

[jesus4u]

Take a look at my code. THis is the error the browser gives me:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ReclaimAmerica.org/test.asp, line 87

Line 87 is flagged with a +++

What is the problem?


sSQL = "INSERT INTO Register(FirstName, LastName, email, userID, address, state, zipcode, phone " & _
"password, userLevel) VALUES ('" & strFirstName & _
"','" & strLastName & "','" & strEmail & "','" & strUserID & "','" & strAddress & "','" & strState & "','" & strZipCode & "','" & strPhone & "','" & strPassword & "',1)"
+++Dconn.Execute sSQL
Dconn.Close
Set Dconn = Nothing

[jesus4u]

Come on someone please take a look

[jesus4u]

CAN ANYBODY HELP ME I'M FALLING!!!

[trr042]

It might be the missing comma. See *

sSQL = "INSERT INTO Register(FirstName, LastName, email, userID, address, state, zipcode, phone *" & _
"password, userLevel)

Cheers

[jesus4u]

Thank you so very much for the help!

That is all it took!

THanks again...these forums are the best....