ASP Error - Syntax Error

[Winder]

strSQL = "insert into course values ('"+request.form("dNAME")+"','"+request.form("cNAME")+"',"+request.form("cNO")+");"

This is the error which i received while trying to do an insert statement into a database.

Could someone help me ?

Error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

Thank you.

[SpagettiProg]

This is probably because you are trying to insert values into a column that does not allow NULL values.

You can change this setting in SQL enterprise manager.

Let me know if you still have problems.

[Winder]

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db1.mdb")

Is there anything wrong with this line of codes?

Thank you, cause i did add in values into the required fields.

[Wayne Wai]

Are you using javascript as your ASP language? If not, you are using a wrong syntax to concatenate string. Use "+" for javascript, use "&" for vbscript.

Try this:
strSQL = "insert into course values ('" & request.form("dNAME") & "','" & request.form("cNAME") & "'," & request.form("cNO") & ");"

[rory]

Make sure they arent null also, especially the Number Field ..

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("./db1.mdb")
 
strSQL = "INSERT INTO course (dNAME, cNAME, cNO) VALUES ('" & request.form("dNAME") & "','" & request.form("cNAME") & "'," & request.form("cNO") & ");"
 
adoCon.Execute(strSQL)