Varing everything is more long winded, local scoping as advised will be less work and less prone to mistakes.
Regards Russ Michaels >From my mobile On 15 Oct 2011 17:18, "James Holmes" <[email protected]> wrote: > > I'll bet you didn't var the query as well: > > <cfset var GetRecord = ""> > <cfquery name="GetRecord" datasource="#Application.AppDatasource#"> > SELECT RecordID,RecordTitle FROM Records > WHERE RecordID = <cfqueryparam value="#arguments.RecordID#" > cfsqltype="CF_SQL_NUMERIC"> > </cfquery> > > Using the local scope (as others have said) makes this less of a pain. > > > <cfquery name="local.GetRecord" ... > > -- > Shu Ha Ri: Agile and .NET blog > http://www.bifrost.com.au/ > > > On 15 October 2011 23:46, Tavs Dalaa <[email protected]> wrote: > > > > > > > > > Tried to Var and cflock, ie: > > > > <cflock name="Lockname" timeout="15" type="exclusive"> > > <cfset Var GetRecord = > > Application.Functions.GetRecordFromRecordID(arguments.RecordID)> > > </cflock> > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
