Secutiry Message for SQL Server 2005 Express

Question

I'm getting the following message when I try to insert data
into a single table using the <cfinsert> tag

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][SQL Native Client][SQL Server]Cannot insert
explicit value for identity column in table 'customer' when
IDENTITY_INSERT is set to OFF.

What do I have to do to change this any help would be greatly
appreciated

cf_dev2 · Answer

Sounds like you're submitting a form field with the same name as the table's primary key (eg. form.CustomerId ).
So CFINSERT is trying to insert the primary key along with the other values. Thats probably not what you want since you're using an identity column.

Try removing the form field with the same name as the table's primary key and it should work.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded