Should have read that better I guess :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net
> -----Original Message----- > From: Shannon Hicks [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 08, 2002 5:07 PM > To: [EMAIL PROTECTED] > Subject: RE: DB locking > > > 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 > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ==^================================================================ 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 ==^================================================================
