It places all queries within the transaction into a single transaction context - so you can commit or rollback all changes made by all of the queries within the transaction context.
--- Billy Cravens -----Original Message----- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:23 PM To: CF-Talk Subject: Using <cftransaction></cftransaction>... Why? Are cftransaction tags necessary for certain types of queries (e.g. queries involving Merant driver access to a DBaseIII database?). I am working with some code from the past and I notice the <cftransaction> tags in some areas but not in others. Recently I have added more stress/queries to the DBaseIII databases and am noticing big slowdowns in the processes that require access to those files... In: http://www.cfcertification.com/cfdocs/CFML_Language_Reference/2_ColdFusi on_T ags/lr2_098.htm They say it can be used to group multiple transactions into one single business event. What does that mean? Does this mean the database will be locked out until all the functions within the <cftransaction> tags are finished? Is this a requirement for certain types of db's? Any help/ideas appreciated, you people have been amazing. Thanks. Charles ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
