clfock can be used for any shared resource where access needs to be synchronised (e.g. files, search collections etc). -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/
On 10 December 2010 06:36, Michael Grant <[email protected]> wrote: > > It looks to me like you keep overwriting the last doc with the next one. > Also, what's with the cflock? I don't see session, application or server > variables anywhere. Unless you can use cflock in a way I've not seen before, > which with CF is completely possible. > > > > On Thu, Dec 9, 2010 at 4:47 PM, sarah mfr <[email protected]> wrote: > >> >> I have a list of students (firstname, lastname, sectionname). I want to >> create a document of excellence certificates. I tried the following but I am >> getting only one page of the first student information. >> Appreciate your help >> <cfinvoke component="cfc.data.excelling" >> method="cfn_Excelling_UptoNowScore" >> sectionid=1 >> scorepercent=70 >> returnvariable="Students"> >> >> <cfinvoke component="cfc.data.section" >> method="cfn_Section_InfobySectionID" >> sectionid=1 >> returnvariable="sectioninfo"> >> <cfoutput query="sectioninfo"> >> <cfset SectionDetail="#sectionname# (#semestername#)"/> >> </cfoutput> >> >> <h1>Excellence Appreciation</h1> >> >> <cfset error = "" /> >> >> >> >> >> <cfif NOT Len(error)> >> >> <cfset pathToRTF = GetDirectoryFromPath(GetCurrentTemplatePath()) & >> "Newcert.rtf" /> >> >> >> <cflock name="NewCert" type="exclusive" timeout="30"> >> >> >> <cfset rtf = FileRead(pathToRTF) /> >> >> <cfloop query="students"> >> >> <cfset rtf = Replace(rtf,"%firstname%","#firstname#") /> >> <cfset rtf = Replace(rtf,"%lastname%","#lastname#") /> >> <cfset rtf = Replace(rtf,"%SectionDetail%","#SectionDetail#") /> >> >> <cfheader name="content-disposition" value="inline; >> filename=cert#Studentid#.doc" /> >> >> <cfcontent type="application/msword" > >> >> <cfoutput>#rtf#</cfoutput> >> >> >> </cfloop> >> >> </cflock> >> >> >> </cfif> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

