Wasn't the ColdFusion MX Bible written by Charlie Arehart from New Atlanta (the makers of BlueDragon)?
Mayby he will share with the list why he stated that omitting BEGIN, COMMIT, and ROLLBACK will bring CFMX to a slow crawl. -Aaron On 2/15/06, Stan Winchester <[EMAIL PROTECTED]> wrote: > The reason you see a lot of code using cftransaction with try/catch is > probably because it comes straight from the ColdFusion MX Bible. They say if > we don't use BEGIN, COMMIT, and ROLLBACK then CFMX will slow to a crawl. > > Putting the cftransaction with try/catch in the action page does work, and it > does catch errors; I just want to do something stupid. So you feel if I > passed the data source as an argument, then you would be okay? > > I'm working in MySQL 4.1 now, so stored procedures are not an option, but > would be the better approach. > > I can put the cftransaction in the cfc, but if I do an insert/update on a > parent record and N children then I may have to write the same queries more > than once since you cannot nest cftransaction tags. I may want to only update > a parent or a single child record without having to update the entire family. > I was thinking I should be able to do the following: > > <cftransaction> > <cfset myDiscount.flushDiscountToDatabase(ArgumentCollection=formParams) /> > <cfloop index="i" from="1" to="#somenum#"> > <cfset myChildDiscount.flushChildDiscountToDatabase(i) /> > </cfloop> > </cftransaction> > > Thanks! Stan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232458 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
