> 1.) Is there anything wrong with putting the cftransaction > with try/catch in the action page? (Assuming data source > arguments are passed - Dave Watts brought up this point) > Putting the cftransaction on the action page does work, and > it does catch errors.
I think I might have been a bit unclear about my point. It's not so much that you have to pass datasource arguments, but simply that for CFTRANSACTION to work, all queries within the transaction need to be using the same database connection. For queries within a page to use the same database connection, they must use the same datasource, username and password. In the original code sample, you couldn't tell whether that was the case, since the actual database queries weren't in the same file as the CFTRANSACTION tag itself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232800 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
