<!--- This view-only example shows the use of CFTRANSACTION --->
<HTML>
<HEAD>
<TITLE>CFTRANSACTION Example</TITLE>
</HEAD>

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">

<H3>CFTRANSACTION Example</H3>

<P>CFTRANSACTION can be used to group multiple queries
using CFQUERY into a single business event.  Changes to data
requested by these queries are not committed to the datasource
until all actions within the transaction block have executed
successfully.
<P>The following is a sample listing (see code in other pane):

<!--- <CFTRANSACTION>
	<CFQUERY NAME='makeNewCourse' DATASOURCE='Snippets'>
	INSERT INTO Courses
		(Number, Descript)
	VALUES
		('#myNumber#', '#myDescription#')
	</CFQUERY>

	<CFQUERY NAME='insertNewCourseToList' DATASOURCE='Snippets'>
	INSERT INTO CourseList
		(CorNumber, CorDesc, Dept_ID,
		CorName, CorLevel, LastUpdate)
	VALUES
		('#myNumber#', '#myDescription#', '#myDepartment#',
		'#myDescription#', '#myCorLevel#', #Now()#)
	</CFQUERY>
</CFTRANSACTION> --->

</BODY>
</HTML>       
