do not insert a value into an identity or auto numbering primary ey field.
You can let the database increment this value for you.
~Simon
> Simon Horwith
> Allaire Certified ColdFusion Instructor
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
>
-----Original Message-----
From: Richard Banks [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 12:42 PM
To: CF-Talk
Subject: ODBC error.
Hi. I'm a CF newbie. I ran into the following error while making my page
All i wanted to do was insert another row with data into the database.
Any help will be greatly appreciated.:
--------------------------------------------------------------------
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 (3:1) to (3:52).
-------------------------------------------------------------------
Thanks.
Richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
