I think that is a good idea for dealing with the problem of orphaned records. I am currently going to go with the concept of the dt_updated in the dB. Seemed like my persistent lock manager was going to take an unnecessary amount of overhead =)
Thanks again for the input, the idea is solid. Take care, Justin -----Original Message----- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Saturday, February 21, 2004 6:06 AM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] [Kind of OT]: Record Locking and Avoiding Race Condi tions? Is the closed for input/ideas -- here is one of mine: Create a persistant structure of record id/timestamp in the manager. Whenever a record is checked out for editing it is checked if that id is in that structure, and if the timestamp is within 1/2 hour or something, then throw error, if not, add now() to the structure. ------------------------------------------------------------- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no ------------------------------------------------------------- ---- Original Message ---- From: "Justin Balog" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 21, 2004 00:44 Subject: RE: [CFCDev] [Kind of OT]: Record Locking and Avoiding Race Condi tions? | Thanks everyone who responded. We looked into the timestamp | solution, and | think it is pretty reasonable idea. We are going to run with that | idea for | now. As always, I appreciate the feedback. | | Take care, | | Justin | | -----Original Message----- | From: Sean A Corfield [mailto:[EMAIL PROTECTED] | Sent: Friday, February 20, 2004 4:50 PM | To: [EMAIL PROTECTED] | Subject: Re: [CFCDev] [Kind of OT]: Record Locking and Avoiding Race | Condi tions? | | | On Feb 20, 2004, at 2:36 PM, Roland Collins wrote: || Hmmmm . . . is it possible to trust the documentation at all then? || You || are || indeed correct - I just created a test script to prove it. But || according to || the CF Docs under "Selecting a function scope": | | http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/udfs31.htm | | There is a comment from the documentation team (12/3/2003) | acknowledging the error in the docs. | | Regards, | Sean | | ---------------------------------------------------------- | You are subscribed to cfcdev. To unsubscribe, send an email | to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' | in the message of the email. | | CFCDev is run by CFCZone (www.cfczone.org) and supported | by Mindtool, Corporation (www.mindtool.com). | | An archive of the CFCDev list is available at | www.mail-archive.com/[EMAIL PROTECTED] | | ---------------------------------------------------------- | You are subscribed to cfcdev. To unsubscribe, send an email | to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' | in the message of the email. | | CFCDev is run by CFCZone (www.cfczone.org) and supported | by Mindtool, Corporation (www.mindtool.com). | | An archive of the CFCDev list is available at | www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
