>> 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?
thanx
barry.b
---------------------------------------------------------------Original Message-----Barry,
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 Concurrency
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]
