post your code. also do you really mean insert new fields? or do you mean insert data into existing fields?
On Mon, 4 Feb 2002, phumes1 wrote: > I keep getting this error when I try to insert new fields into my databas e. > > Error Diagnostic Information > ODBC Error Code = 23000 (Integrity constraint violation) > [Microsoft][ODBC Microsoft Access Driver] The changes you requested to th e > table were not successful because they would create duplicate values in t he > index, primary key, or relationship. Change the data in the field or fiel ds > 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; Q3124 61) > Remote Address: 192.139.241.145 > HTTP Referrer: http://127.0.0.1/test/admin/profiles/env_Add_Form.cfm > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
