>>Making a web app retain some idea of a cohesive session across HTTP requests is a work around of the inherent statelessness of the protocol.
Ok, but workaround or not, we are able to have sessions and keep track of them. >>All a session is is knowing that two distinct requests within a given window of time are related And this is all what we need to develop full featured databases applications, and this is what we all are doing using ColdFusion. >>Here's the rub - let's say someone goes to an edit form on a site, and the data row is then locked. Then they decide they want to do it later instead, so they browse off to some other site. How do you release the lock? Like in any other application: with a time limit. whether the application is under DOS, Windows or CF, a lock must have a time limit. You had exactly the same kind of situation in Clipper when a user decided to take his coffee break after just having locked a record for editing. The fact that the user has access to the application through Internet makes no difference. >>Now, you could have a timeout on the lock, but it would have to be fairly short (minutes at most) to not be problematic. The more at risk the data is for a race condition, (i.e. the more likely a particular row is to have multiple editors) the more problematic a timeout mechanism is in this scenario. No difference with any other application >>In either case you could probably solve it using some sort of ping mechanism on the page to make sure they are still there, Gee, you are improving the mechanism! ;-) Make it Ajax! >but now you have a bunch of extra network chatter going on while someone sits and looks at the form. Peanuts! >>You are correct that there is no standard mechanism that handles this well. As others have pointed out, it's possible to handle in your code. My point is precisely that this is weird, because all these mechanisms were easily available back in the 80's, in dBase, the ancestor of all popular database systems. >>I would certainly be all for someone coming up with a better toolset to manage this sort of thing. As I say, when I'll have some time, I'll have a look to see if there is any solution through ODBC-JDBC and may develop some CFX to handle record locks. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
