On 5/30/05, Jared Rypka-Hauer - CMG, LLC <
[EMAIL PROTECTED]> wrote:
Alrighty then!
My guess would have been that there was some sort of CF instance managing which records were locked... what freaked me out is that I may have missed something in the last 6 years of CFing that would have made my life a lot easier. :)
I've never had a situation where these long-lived locks were important, so I'm not in need of it at this point. Yay me, eh?
Anyway, thanks for the deeper explanation (and you too, Bill)... if for no other reason than that when I DO need it I'll know where to start without having to dig around for the answers.
Quick question, though... why use a QofQ when you could use something like a struct or even an in-memory XML doc to manage tables, rows, and so on, to handle the locking? It sounds like a lot more work when you could just have a "locked entity" structure for each entity type and store the locks in something other than a query object...
Laterz!
JOn 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
--
---------------
-------------------------------------
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]
--
[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]
