> try using a CFTRANSACTION like this... > > <cftransaction> > <cfquery name=""> > EXECUTE sp_newmeal.... > </cfquery> > </cftransaction> > > It is my understanding that the CFTRANSACTION will single > thread ALL requests to the specified DB (instead of just > row-level or table-level locks). That will prevent > concurrent threads from inserting the same ID
I don't think that's correct. CFTRANSACTION doesn't single-thread all requests to the DB - and a good thing, too. Instead, it tells the database to treat the queries contained within the CFTRANSACTION tags as a single transaction. How the database actually handles the transaction is up to the database, to a degree - some databases may lock an entire table, others may lock a page, others may lock a row. In addition, you can use the ISOLATION attribute to specify the desired isolation level, which basically boils down to how optimistic you are about the likelihood of concurrency issues, or whether you even care about them. 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 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
