try using a CFTRANSACTION like this... <cftransaction> <cfquery name=""> EXECUTE sp_newmeal.... </cfquery> </cftransaction>
It is my understanding that the CFTRANSACTION will single thread ALL requests to the specified DB (instead of just row-level or table-level locks). That will prevent concurrent threads from inserting the same ID +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists