how to have sql server generating primary keys oninsertion of record set

[surfinjay]

Hi everyone,

I need some help here. I am building a website for a company, which requires
customerregistration, buying products and so on. My question now is the
following:

I have created all the databases I need on my SQL Server 2005 and have
connected coldfusion to it successfully. I can read in records via the
coldfusion insert record wizard. But I was hoping sql server to assign my
primary keys automatically since i have put them on Identity and configured the
seeds and so on. But everytime i try to read in the records on the site it
tells me my primary keys cant be null. So does coldfusion now have to assign
the keys or can I have sql server create them (which i would prefer) somehow.

Id be real glad for some feedback

Thanks
Jay

[SQLMenace]

Make the field an identity column

[url]http://sqlservercode.blogspot.com/[/url]

[surfinjay]

well as i said all my primary keys in sql server ARE set to integers, identity
true,seed 1 and increment 1.
yet if i try to read in data, of course im not reading in the keys. it tells
me:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]DEFAULT or NULL are not allowed
as explicit identity values.

So therefore i suppose that sql server did not give them values when i thought
it was supposed to.

[SQLMenace]

how many columns in the table and how many are you passing in?
you have to pass in 1 less than the sum of all the columns

Make sure you don't have an extra comma somewhere

[surfinjay]

Hi

well i tried this example:

i have a table called productinfo with the columns: productnr, prodctname,
version, build and desscription.

when creating an insertion form with the coldfucsion insertion wizard i take
out the productnr of the listed columns when having to select which columns i
want to create frms for, because of course i dont wnat the key to be read in.
Therefore i have 5 columns and i am reading in 4 coliumns, ust like you said.
Still im getting the same error ?!?!

[surfinjay]

i got the probem!

Dreamweaver did not update the query where as i had already changed the form.
SO now i got it all roight.

thx anyway
Jay