I try to further fluff my example before - maybe it will help someone.
We have a CMS product with pages which are composed of various programs/portlet/data windows... Each of those little programs has a variety of display modes with various settings that can be modified to alter they way the data is displayed (some very, very different from each other)..
the page itself can also be edited to add new programs, remove programs, move programs, etc.. (plus associate the collection of programs with different datasets (folders of data) and set the page to have some "folders" and much much more..
When a user, who has authorization, wants to edit a page, they choose the edit page option, the page system then checks if the page is "locked" if not it tries to lock it, if it succeeds (someone else didn't lock it in that little window) then the page goes into edit mode.
All settings directly related to that page and it's subordinate programs are then locked. The data that feeds into those programs isn't locked.. Just the setting data.
The "page" table has a single entry per page. There is a column that identifies if the page is being edited by someone and the datetime it was locked for editing.
I know I'm probably not answering your question. Sorry - I'm too tired to really think much right now. The weather here today was beautiful so I spent a lot of time outside playing.
Bill
On 5/29/05, Barry Beattie <[EMAIL PROTECTED]> wrote:
>> is there some sort of DB locking available to us that I haven't seen in CF?oh, I wish there was! the hoops one has to go thru to get table and (esp in this case) row level locking! (another feature request for Tim Buntel and CF8, perhaps?)Jared, it's a singleton CFC in server scope (for us - Application otherwise) that uses a QofQ (believe it or not) as the "guts"...so a cflock will be needed to serialise the access to this CFC (to stop two locks hitting at the same time)(to clarify: "cflock" != "data (application) lock" != "database table lock")where it get's complicated is when you're dealing with "entities" and you need to lock more than one (db) record that makes up that entity...("sorry you cannot edit this student - the students' parent's address is locked for editing")...and then bring in editable datagrids which deals with many entities...>> I'm interested...interested enough to go down this route? I hope your business rules are easier...Dave Watts made some points on this that might be worth considering...has anyone else done anything like this?thanxbarry.b-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jared Rypka-Hauer - CMG, LLC
Sent: Monday, 30 May 2005 10:14 AM
To: [email protected]
Subject: Re: [CFCDev] Repost: SQL ConcurrencyBarry,
Do you propose a db table, an application structure of some sort, or (this is the part I'm missing) is there some sort of DB locking available to us that I haven't seen in CF?
I ask specifically because I've never heard of being able to lock records (other than with cftransaction, which isn't really explicit locking per se) in the DB from the CFMX side. Is there a specific lock table for specific DBs?
I'm interested...
Thanks,
J
On 5/29/05, Barry Beattie <[EMAIL PROTECTED]> wrote:>> choose to edit data -> edit the data -> preview the changes -> commit changes and unlock dataBill, just to have a closer look at the idea: <snipped>
--
---------------
-------------------------------------
Buy SQLSurveyor!
http://www.web-relevant.com/sqlsurveyor
Never make your developers open Enterprise Manager again. ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
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' as the subject of the email.
CFCDev is run by CFCZone ( www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
--
[EMAIL PROTECTED]
http://blog.rawlinson.us
If you want Gmail - just ask. ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon
http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
