Tom Muck

Alpha Dog Blues Band
Home page
All articles
All Extensions | Extension News | Extension FAQs | Customer Login
Books authored or co-authored by Tom Muck
Extensions, books, and other products | Customer Login
Your current cart contents
Tom-Muck.com Blog | CMXTraneous Blog | Flash Remoting Blog
About the site

Blog

Tom Muck's BlogTom Muck's Blog

News and Views

Record locking system for ColdFusion 7

Thursday, January 18, 2007 10:21:03 PM

The second part of my article on record locking using CF 7 went live yesterday at Community MX. I saw some applications using Flex and the record locking capabilities and decided it was something I wanted to do with a regular CF application. Where I work we have quite a few simultaneous users who access job records -- one person will create the record, but then in the span of a few hours several others have to update the records with information. This was the perfect place to put the theory to work. Basically, an array is created in application scope that contains stucts with record ids and user ids. If a user is logged in and attempts to update a record that has a lock on it, it will be viewable only. The locks have a user-defined time limit on them not related to sessions, and a user can only lock one record at a time. Because the locking is done at the application level rather than at the database level, the lock can span multiple tables and update statements that pertain to one record id.

The first part sets up the sample data and the pages, and the second part shows all the locking functionality. The articles are free for members and a small fee for non-members.

Implementing a Record Locking System in ColdFusion 7 - Part 1
Implementing a Record Locking System in ColdFusion 7 - Part 2

Category tags: Community MX, Dreamweaver, ColdFusion

Before posting comments or trackbacks, please read the posting policy.

Full Blog Calendar

Pay me securely with your Visa, MasterCard, Discover, or American Express card through PayPal!
Pay me securely with your Visa, MasterCard, Discover, or American Express card through PayPal!
About | Privacy Policy | Contact | License Agreement | ©2002-2022 Tom Muck | Dreamweaver Extensions