Situation:
Two MSSQL queries run via <cfstoredproc>s, the second of which uses the
result of the first.
The queries are set within a simple <cftransaction></cftransaction> block.
If neither of the queries utilises or sets a session variable, can anyone
see any reason to have the queries within a readonly session cflock,
within the <cftransaction> block?
ie
<cftransaction>
<cflock>
<cfstoredproc1>
<cfset somevariable from storedproc1>
<cfstoredproc2>
</cflock>
</cftransaction>
Seems unnecessary to me.....
Terry Riley
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
