I have several pages where many inserts/updates are being performed within a loop: 50-200. I would like them to all go through or have them roll back. I am still quite green and as such, I have a few questions for y'all:
1. Is there a limit to how many queries can be within cftransaction tags? 2. If all the inserts/updates are to one table, will the table be locked or the whole database? 3. Does the transaction tag slow the process down? 4. Does MS Access support the concept of transactions or do I have to wait until I switch the database over to MS sql. 5. Does the transaction process notify of success or failure? Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220618 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
