ASP Recordset Insert

[Aaron Bertrand - MVP]

Does anybody have any good articles or tips on how to do a insert when you

have a primary key that is auto increment?

You don't mention that column, because you aren't supposed to be supplying a
value to it. Let's say your table is:

Table:
foo
Columns:
ID (AutoIncrement)
Name (text(32))
Active (int)

Your insert statement would be:

INSERT foo(Name, Active) VALUES('blat', 1)

 

[Biggie]

I'm using ASP 3.0 and SQL Server 2000. I do a insert from a form into a
table. When I do the insert I get a error that the primary key cannot be
Null.

Does anybody have any good articles or tips on how to do a insert when you
have a primary key that is auto increment? Or how to handle the primary key
insert.

 

[Manohar Kamath [MVP]]

http://www.aspfaq.com/show.asp?id=2174