In CF5, is it still considered good practice (or was it ever) to put a
readonly session cflock around a cfstoredproc that reads from a
session variable, on the basis that no automatic lock checking is set in
CFAdmin?
as in:
<cflock scope="session" type="readonly" timeout="10">
<cfstoredproc procedure="spr_addemployee" datasource="foo"
returncode="no">
<cfprocpraram type="in" cfsqltype="cf_sql_integer"
dbvarname="@userid" value="#session.userid#">
<cfprocresult name="recordinserted" resultset=1>
</cfstoredproc>
</cflock>
TIA
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]
