Hi, Thanks for the advice. The problem eventually turned out to be that I was using cfinsert instead of the sql insert statement. Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft & More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ----- Original Message ----- From: Hayes, David <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 2001 6:28 PM Subject: RE: Problem with edit operation creating duplicate values in a Mi crosoft Access database > Off the top of my head, it sounds like the edit table action page is trying > to do an insert. Or you might have an index on the table that doesn't allow > for duplicates. > > Turn on debugging so that you can see the actual SQL that's being sent to > your Access database. > > -----Original Message----- > From: Hubert Earl [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 3:02 PM > To: CF-Talk > Subject: Problem with edit operation creating duplicate values in a > Microsoft Access database > > > Hi, > > I've built a web page with two html tables, one with the heading Users and > the other with the heading Items & Artists, showing data from a Microsoft > Access database. Each html table accesses a separate Access table within > the same database. Each html table also allows the user to edit, delete > from or add to its Access table. After building the Users table, with its > associated form and action files, I made sure it worked for all three > operations. I then built the Items & Artists table and its associated form > and action files by copying the code in Users and changing relevant names > (like column headings etc.). However, when I try to edit the data in the > Items & Artists html table, I get the following error message: "The changes > you requested to the table were not successful because they would create > duplicate values in the index, primary key, or relationship" (tho the delet > from and add to operations work OK). > > This puzzles me greatly, since the code used in the Items & Artists table, > form and action files is identical to that used in the Users table, form and > action files, with the sole exception being table, variable, form, file and > heading names (ok, that's quite a few names, but the underlying code > structure is the same). What should I be considering as a possible cause of > the problem? > > Sincerely, > --- > Hubert Earl > > ICQ#: 16199853 > AIM: hubertfme > > My Jamaican Art, Craft & More Online Store: > http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
