I'm grateful Adam gave further in-site regarding how to use CFTRANSACTION. Now Back to my original questions: Is there anything wrong with putting the cftransaction with try/catch in the action page as long as the data source as an argument? Putting the cftransaction on the action page does work, and it does catch errors, I just would like to know if there is some reason why it might be a bad idea.
(Side note: I really donât like passing dsn usernames and passwords any more than absolutely necessary. I could modify my _dsn.cfc to handle multiple dsn's with the us/pwd hard coded in the _dsn.cfc) I agree transaction processing in a stored procedure would be the best case scenario, but I'm working in MySQL 4.1, so that is not an option. I could put the cftransaction in the cfc, but if I do an insert/update on a parent record and loop over a bunch of child records 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> I greatly appreciate the feedback all of you have offered! This list has been a great blessing helping me to improve as a CF developer. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232565 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
