Re: Inserting new fields into database...

[Karen Harker]

This is a database problem.  You need to make sure your identity field is unique � if it is an Access database, use Autonumber as the datatype for the identity field.  If it is an SQL database, use these properties for the identity column: Datatype: int (integer) Allow nulls: UNchecked Identity: CHECKED Primary key   Those are the only RDBMS with which I'm familiar.       Karen R. Harker, MLS UT Southwestern Medical Library 5323 Harry Hines Blvd. Dallas, TX  75390-9049 214-648-1698 http://www.swmed.edu/library/ >>> [EMAIL PROTECTED] 2/4/02 1:14:56 PM >>> <code> <cfquery name="update_profile" datasource="profiles"> Insert into profile (profile_ID, env_var, destination) VALUES ('#FORM.profile_ID#', '#FORM.env_var#', '#FORM.destination#') </cfquery> </code> I keep getting this error when I try to insert new fields into my database. Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] 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. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:53). Date/Time: 02/04/02 13:39:38 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461) Remote Address: 192.139.241.145 HTTP Referrer: http://127.0.0.1/test/admin/profiles/env_Add_Form.cfm ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org