Are you trying to insert a value into the Profile_ID field?
-----Original Message----- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 2:28 PM To: CF-Talk Subject: RE: Inserting new fields into database... Profile_ID is the primary key and the DataType is AutoNumber NewValues = increment Indexed = Yes (No duplicates) Do I need to change the database settings on the primary key? At 02:14 PM 2/4/2002 -0500, you wrote: >what's the primary key in the table? sounds like you're inserting a row >with a duplicate primary key value (which is, of course, what the error >message says). > >christopher olive, cto, vp of web development >atnet solutions, inc. >410.931.4092 >http://www.atnetsolutions.com > > >-----Original Message----- >From: phumes1 [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 04, 2002 2:14 PM >To: CF-Talk >Subject: Re: Inserting new fields into database... > > >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 > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
