The error you are getting suggests that your PK value is not unique for the row that you are inserting into "tblBenefit". Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP?
-- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 20, 2002 8:38 AM > To: CF-Talk > Subject: Annoying DB question > > > I'm having an issue > "Error","TID=361","05/20/102","10:54:12","ODBC Error Code = > 23000 (Integrity constraint violation)<P> [Microsoft][ODBC > SQL Server Driver][SQL Server]Violation of PRIMARY KEY > constraint 'PK benefit'. Cannot insert duplicate key in > object 'tblBenefit'.<P><P> SQL = "sp_newmeal" " > > Heres whats happening we have 8 rows in the db that hold meal plans > when we change them we remove the old plans and insert new plans > sometimes if you hit refresh enough it causes a ERROR above > to be thrown. > What i did was put the enter thing into a transaction with > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE > > and it still throws the error when the SQL notes say it > shouldnt happen like that > any ideas? thanks > > > Bill Wheatley > Senior Database Developer > Macromedia Certified Advanced Coldfusion Developer > EDIETS.COM > 954.360.9022 X159 > ICQ 417645 > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
