Transactions control when data gets committed as well as how long some locks are held. They do not necessarily keep other processes from modifying parts of a table you are touching. That's when isolation levels and locking behavior comes into play.
~Brad -------- Original Message -------- Subject: RE: SQL Gurus... obtaining the correct Incremental ID From: "Che Vilnonis" <ch...@asitv.com> Date: Wed, April 28, 2010 3:59 pm To: cf-talk <cf-talk@houseoffusion.com> I am using the cftransaction tags. Honestly, I was not absolutely sure that I needed to do anything else and that is why I posted my original question. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm