Page error

[Dinobot2]

I'm new to ASP and I have a problem with one of my pages. I created a html page and posted the information to my asp form. the asp form is supposed to insert the information into an access database. the code I used is this-

MySQLcmd="select Password, FirstName, LastName, Secret_Question, Secret_Answer,email from dbs_table;"

Set rs=MySQLcon.Execute(MySQLcmd)

dim MySQLinsert
MySQLinsert="insert into dbs_table (FirstName,LastName, email, password, Secret_Question, Secret_Answer) values('firstname', 'LastName', 'Email', 'password2', 'secretq', 'secreta');"


The error I keep getting is this-

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/workload/newuser.asp, line 20


it says that there is a syntax error into the insert into statement but I don't see anything. I copied it from the book and I've viewed some pages and it's all the same. I still don't see where the syntax is.

anyone knows what's wrong?

 

[Sheco]

The first thing I usually check is if the variable holding my SQL command actually holds the value that I think it does...

So given the variable names above I would add something like this for debugging purposes:
Response.Write "<BR><BR><BR>The SQL syntax:<BR>" & MySQLinsert & "<BR><BR>"
Response.End

Then i would re-run the page and take a look at what it spits out... if it still looks ok then maybe i would select it with the mouse and copy it to the clipboard, then open my database and run it directly in the query tool.

 

[onpnt]

there are some simple ways to prevent these types of errors..also, I don't think I have ever let a SQL statement hit my DB without doing exactly what Sheco tips to above. you should never let the execute happen prior to testing it.

here are the FAQ'a that should get you farther on..
Development practices when using SQL/Interfaces faq333-4896 How can other tools help me develop ASP faq333-4770