HomeCalendarFAQSearchRegisterMemberlistUsergroupsLog in

Share | 

 Controlling Database Transactions in ColdFusion MX

Go down 

Number of posts : 1850
Age : 55
Registration date : 2008-03-08

PostSubject: Controlling Database Transactions in ColdFusion MX   Fri 4 Apr - 16:48

Many developers choose ColdFusion for web application development because it is easy to use and because CFML minimizes the complexity of common application coding activities. This allows developers to spend more time working on the more complex functionality in their applications. One way in which ColdFusion simplifies the development process is in the way it connects to and extracts data from a database-usually one of the first things that a ColdFusion developer learns. This is accomplished with the cfquery tag.

As easy as it may seem to be to make your database accessible to web applications, doing so efficiently is not as simple as putting cfquery tags on a page. Many individuals can browse a web application simultaneously. When web application users concurrently query database data, it is possible that some users may receive incorrect data if the application doesn't handle queries in the context of that user's current transaction. In fact, even a single application visitor may be able to create or retrieve invalid data if that user's database interaction isn't executed in the protected scope of a database transaction. The classic example of invalid data retrieval would be that of an application that inserts a new record then executes a select statement in order to retrieve the unique id of the freshly inserted row; but instead of receiving the correct ID, the app receives the unique id of a row inserted in a concurrent transaction. In this article, we will examine:
Back to top Go down
View user profile
Controlling Database Transactions in ColdFusion MX
Back to top 
Page 1 of 1
 Similar topics
» Ami Database till 04/10/2012
» FORD - Re-enters Sri Lanka as a subsidiary of Softlogic
» Stock transaction
» Passign Parameters to DirectFN
» Expolanka Holdings buys controlling stake in Norfolk Foods for Rs. 300 m

Permissions in this forum:You cannot reply to topics in this forum
Job98456 :: Databases-
Jump to: