The problem we are seeing (some of the time, not each and every time) is I have a list of numbers (comma delimited) comeing over from a multiselect box. Instead of tyring to figure out what ones are in the DB as compared to what ones are in the list, I just delete the entries from the DB totally (in relation to a specific ID) and then insert the passed in list one element at a time by looping over a query. It seems that some times the delete is not committing and when I try to insert I get constraint violations because the DB still thinks the values are in the table.
does that make sense? Mike -----Original Message----- From: UXBinfo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:16 PM To: CF-Talk Subject: RE: transactions Mike, We also still use CF4.0.1 (and yes it seems to scare people away in the forum). We perform the same type of queries, delete followed by an insert, without a problem in several of our applications. What is the problem you are seeing? Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -----Original Message----- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 11:19 AM To: CF-Talk Subject: transactions Hello everyone. I could use some thoughts on the following problem I am having. I have a query that deletes all records in a table with a certain value in the ID field. I then turn around and insert records back into the same table (some of which might be the same as I just deleted). What I think is happening is that the delete is not being committed to the DB before I do the insert. Unfortunately I am on CF 4.01, which does not make life any easier. Any insight would be greatly appreciated. My code thus far is below. <cftransaction> <cfquery datasource="#request.Datasource#"> DELETE FROM HazMMSLink WHERE Haz_ID = #attributes.HazardID# </cfquery> <cftransaction action="COMMIT" /> </cftransaction> <cfif attributes.SelectedMakeModelSeries NEQ 0> <cfloop index="i" list="#attributes.SelectedMakeModelSeries#" delimiters=","> <cfquery datasource="#request.Datasource#"> INSERT INTO HazMMSLink ( Haz_ID, MMS_ID, Record_Change_User_ID ) VALUES ( #attributes.HazardID#, #i#, #request.UserInfo.UserID# ) </cfquery> </cfloop> </cfif> Thanks, Michael T. Tangorre ---------------------------------------- MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 ---------------------------------------- Golden Rule: "He who has the gold, makes the rules!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
