> To my knowledge, as long as both tables are in the same > database, using <cftransaction action="rollback" > isolation="serializable">(queries...)</cftransaction> > effectively creates the lock you are looking for (equivalent > to an exclusive lock but for a database). By default the > isolation attribute is "Serializable" so you really don't > have to specify this one. The default value for the ISOLATION attribute isn't "SERIALIZABLE", it's "READ_COMMITTED". Also, I don't think you'd ever want to use ACTION="ROLLBACK" as the action for an entire transaction - it's used for partial rollbacks within a larger transaction. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
