SQL string can't update database

[Supremus]

G'day,

SQL="INSERT INTO KQPlayers VALUES(" & _
"," & _
"'" & Request.Form("username") & "'," & _
(--snip--)

Conn.Execute SQL

This generates an error because my first field in the table (line 2 in the sql statement) is an AutoNumber and I don't know how to skip adding values to that field.

The above code gives me
Syntax error in INSERT INTO statement.

If I put a 0 in the first field before the comma I get ...
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Just to test it, I tried ...
Sql="insert into Players (username) values('" & Request.Form("username") & "'" )
I get

Error: Missing Fields
You must enter all fields to proceed.

[shweta123]

Give sql like this

SQL="INSERT INTO KQPlayers VALUES(
"'" & Request.Form("username") & "'," & _
(--snip--)

don't put anything for the autonumber field.

Shweta

[gyung]

I have another field, cID which is a Primary Key AUTO_NUMBER. I skip it and the DB takes care of it.

SQL = "INSERT INTO class (cName,cShow) VALUES('"
            SQL = SQL & cName & "','" & cShow & "');"
            'response.Write(sql)
            'response.End()
            'Open connection
            'objConn.open
            objConn.Execute SQL
 
            closeConn()

[pegassi]

I have another field, cID which is a Primary Key AUTO_NUMBER. I skip it and the DB takes care of it.

SQL = "INSERT INTO class (cName,cShow) VALUES('"
            SQL = SQL & cName & "','" & cShow & "');"
            'response.Write(sql)
            'response.End()
            'Open connection
            'objConn.open
            objConn.Execute SQL
 
            closeConn()

if cID is sequential field defined by DBMS, i think u shouldn't type it in INSERT query. If i was you I would do this

"INSERT INTO class (cShow) VALUES("& _
" ' "& cShow & "');"
'response.Write(sql)
'response.End()
'Open connection
'objConn.open
objConn.Execute SQL

closeConn()

I think that'll work properly