Well the value is not unique becuase the key is on MEALID and MEALTIME which is like 1 = monday time = 1(breakfast)
i just was reading about that serialize isoloation level and thought that should do the trick Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 ----- Original Message ----- From: "Van Vliet, Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 11:50 AM Subject: RE: Annoying DB question > 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 > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
