SQL and autoupdate rows

[Shortie]

I am writing a Cold Fusion application using Access. How do I insert a row that has an auto updatable primary key? Do i need to specify that column in the insert statement?(i tried this but it didn't work
INSERT INTO users VALUES ('#FIRSTNAME#','#LASTNAME#');
Cold Fusion asks for that 3rd column's value....)

 

[Amiel]

try this...
... and, loose the pound signs.

"INSERT INTO users (fldFirstname, fldLastname) VALUES ('FIRSTNAME','LASTNAME')"


Amiel
amielzz@netscape.net