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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
