My personal preference would be to make a Store procedure that does it... It would follow the same basic concept as you already have only instead of it being written in CF it would be in SQL.
Transaction serializable would be a good idea too. Adam H On Tue, 8 Mar 2005 07:52:51 -0600, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote: > Tony, > > I've messed with this, but not for a long, long time... since the CF5 > days, because the tags never seemed to work as expected. > > I'd recommend you actually try something like this: > > <cftransaction isolation="REPEATABLE_READ"> > <cftry> > <cftransaction action="begin" /> > .....code here........ > <cfcatch type="any"> > <cftransaction action = "rollback" /> > <cfrethrow /> > </cfcatch> > </cftry> > <cftransaction action = "commit" /> > </cftransaction> > > Be sure to test, but if I understand the concept correctly (which I do > ;) ) this should be a good start in the right direction. It the very > least, it's got me thinking to start using cftransaction more > consistently in my apps. > > Laterz, > J > > > On Tue, 8 Mar 2005 08:37:33 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > > :) thank you adam... > > > > any idea, how i could restructure it to achieve that? > > > > thanks. > > tony > > > > -- > Continuum Media Group LLC > Burnsville, MN 55337 > http://www.web-relevant.com > http://cfobjective.neo.servequake.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197818 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
