Unfortunately, you're now at the tip of the iceberg of issues you'll have trying to implement this.
CFTRANSACTION only works while a .cfm page is being processed. It does nothing for while a user is entering info on a HTML form. There are going to be many opinions on what to do about this, but the basic concept is this: you have to store a flag that is globally accessible, and you have to worry about cleanup. The web is stateless, and that's the biggest problem with locking rows. Shan -----Original Message----- From: Balazs Wellisch [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:44 PM To: [EMAIL PROTECTED] Subject: RE: DB locking Exactly, but what if they just leav their browser and never finish what they were doing. Then the row stays locked. So could I tie this to a session variable that would unlock the row when it expires? I can't believe that there wouldn't be some low level db solution for this... -----Original Message----- From: Shannon Hicks [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: RE: DB locking You could add a status column to the table, and flag when it should be "locked". The problem is un-locking the row too. Welcome to the wonderful world of workflow. Shan Shannon Hicks, Senior Developer Macromedia ColdFusion 5 Certified Developer duoDesgin Internet Design, Technology & Marketing 847-491-3000 main | [EMAIL PROTECTED] 847-491-3100 fax | www.duoDesign.com 847-491-7128 direct -----Original Message----- From: Balazs Wellisch [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: DB locking Hi all, this isn't exactly a fb3 specific question but you guys might be able to help me. I have a problem where I need to restrict access to a row in a database table to one user at a time. I need to prevent users from reading or changing data in a table while that row is open in another user's browser. Is this even possible? Can I use cflock for this purpose? Knowing that the web is a stateless system how do I even know if that row is still open? Can I tie locking to a session? I'm using CF5 on Win2K with SQL2K. Any help would be appreciated. Thanks, Balazs ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
