what is wrong with this?

[Ablecken]

What is wrong with this statement.


INSERT INTO test (ID,One,Two) VALUES (7,test,test)
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/login/action.asp, line 54


it looks like this

mySQL = "INSERT INTO test (ID,One,Two) "
mySQL = mySQL & "VALUES (" & newid & "," & newOne & "," & newTwo & ")"


response.write mySQL
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ 
"\\premfs3\sites\blah\blah\dbase.db;" & _ 
"Persist Security Info=False;"
Set Conn = Server.CreateObject("ADODB.Connection") 



conn.open sConnString
conn.execute(mySQL)


Conn.Close

any help?

 

[tlbroadbent]

You should enclose the literal values "test" in quotes. I'm not sure whether single of double quotes are needed.

INSERT INTO test (ID,One,Two) VALUES (7,"test","test&quot
Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm