At 02:52 PM 2/18/03 +0000, Andre Mohamed wrote: >Thane, > >No need to have a separate "CommitWrite" variable. Just do this: > ><cftransaction><!--- Begin is implied ---> ><cftry> > <cfloop> > ...DB Inserts here... > </cfloop> ><cfcatch type="Database"> > <cftransaction action="rollback"/> ></cfcatch> ></cftry> > ></cftransaction><!--- Commit is implied ---> > >Provided you want all inserts to be performed or none at all...otherwise >you need to adjust where the loop is etc.
Ok. Thanks. T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
