At my highschool im in charge of settin up an ASP database for the page. I have been messing around using the "webthang" tutorial trying to get used to it. I got to the add part of the tutotial and ran into an error. The error was this
• Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/sportasp/add.asp, line 115
Line 115 says the following: MM_editCmd.Execute

If you could help me figure this out greatly appreciated! If this isnt enough information tell me so i can fix it

Check your SQL query statement.

Without the the query, it is not possible to answer your question.

"INSERT into mytable(firstname,lastname) values ('" & fname & "','" &lname &"')

besides, in ASP, the single quoted information must be passed as 2 single quoted.

Check this thread.
http://www.webmaster-talk.com/showthread.php?t=16131

Dreamweaver adds its own code at here and there. It is simple to work with DW, once you learn ASP.

Visit http://www.aspin.com
http://www.aspfree.com
http://www.learnasp.com

for more tutorials.

• Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/sportasp/add.asp, line 115
Line 115 says the following: MM_editCmd.Execute
OK HERE IS THE ERROR AGAIN -- IT SAYS LINE 115 is the error but our line (108) is the insert statement __________________________________________________ ___________________-_
(line 108)MM_editQuery = "insert into" & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"

(line 115) mm_editCmd.execute


I dont understand what the problem is!!! If you need more info send me a private msg
Please speak in asp noobie language.

The error says that " Syntax error in INSERT INTO statement "

It means that your SQL statement is not correct.
You need a space at "insert into".
Like "INSERT INTO ". & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"

Hope this helps.

Put a space still gettin the same error any other suggestions?

On line 109 put this:

response.write "Query=" & MM_editQuery

then tell us what you see.

I got nothing perhaps I should start over