Row-level locking isn't supported in the default myISAM table type, but after a bit of research I see I *can* use an InnoDB table type in conjunction with mySQLMax, which supports both row-level locking and transactions. That'll work.
Thx! --Matt-- ---------- Original Message ---------------------------------- from: [EMAIL PROTECTED] (Ben Johnson) Reply-To: [EMAIL PROTECTED] date: Mon, 3 Jun 2002 17:03:34 -0600 > <CFQUERY DATASOURCE="#request.foo#"> > UPDATE entrycount > SET > entrycount.InstallFlash=(entrycount.InstallFlash+1) > WHERE > entrycount.ID = 1 > </CFQUERY> Your database should lock the table/row automatically. I don't believe you need a CF lock as well. Ben Johnson Hostworks, Inc. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
