-
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
-
Come on someone please take a look
-
CAN ANYBODY HELP ME I'M FALLING!!!
-
It might be the missing comma. See *
sSQL = "INSERT INTO Register(FirstName, LastName, email, userID, address, state, zipcode, phone *" & _
"password, userLevel)
Cheers
-
Thank you so very much for the help!
That is all it took!
THanks again...these forums are the best....