Here is the thread that helped me ----- Original Message ----- From: "Mark Zukiwsky" <[EMAIL PROTECTED]> To: "Sean Renet" <[EMAIL PROTECTED]> Sent: Saturday, March 04, 2000 11:11 PM Subject: Re: Flash w/ CF > >Mark I went to flasher and I do not see an archive for the list. could you > >forward me your post. I am trying to figure out how to use flash to > >retrieve variables from CF also. > > Hi Sean, > > Here's my post to the Flasher list from last week. They were asking > the same thing you were. > > Just a note about the use of lists - this code was originally for use > in Director Shockwave. I used lists so I could suppress white space > and extraneous tab characters that were ending up in my variables, > and for passing cf lists directly to Lingo Lists. > > Contact me if you have any questions. > > Mark Zukiwsky > Edmonton, Canada > > -------------------------------------------------------------------------- ----- > Date: Thu, 2 Mar 2000 14:24:00 -0700 > To: Flash List > From: Mark Zukiwsky <[EMAIL PROTECTED]> > Subject: Re: FLASH: Can anyone help me with flash and Cold Fusion? > Cc: [EMAIL PROTECTED] > Bcc: > X-Attachments: > > Hi Sarah, > > Here's an example of a ColdFusion template that I'm using to get data > into Flash. I'm using the POST function in Flash to fetch my > variables. My Flash Post action is something like: > > Set Variable: "baseURL" = "http://mark.foxmicro.net/flash/" > Set Variable: "CFtemplate" = "getMenuData.cfm" > Set Variable: "SiteID" = 1 > Set Variable: "eof" = 0 > Set Variable: "index" = 1 > Load Variables (baseURL & CFtemplate, 0, vars=POST) > Go to and Play ("Check") > > That calls the following ColdFusion template: > ------------------------------------------------ > <cfsetting showdebugoutput="no"> > <cfsetting enablecfoutputonly="yes"> > <cfcontent type="text/plain"> > > <!--- get training menu data, be sure to pass FORM.siteID ---> > <cfquery name="flashtext" datasource="MyDatabase" dbtype="OLEDB"> > SELECT busUnit, unitName, novaUnit, activeUnit > FROM UnitTBL > WHERE SiteID = #Trim(FORM.SiteID)# > ORDER BY novaUnit, unitName > </cfquery> > > <!--- Convert query results into list ---> > <cfset unitList = valueList(flashtext.busUnit)> > <cfset nameList = valueList(flashtext.unitName)> > <cfset novaList = valueList(flashtext.novaUnit)> > <cfset activeList = valueList(flashtext.activeUnit)> > > <cfset unitReturn = ""> > <cfset nameReturn = ""> > <cfset novaReturn = ""> > <cfset activeReturn = ""> > <cfloop index = "unitIndex" from = "1" To = "#ListLen(unitList)#"> > <cfset tempUnit = ListGetAt(unitList, unitIndex)> > <cfset unitX = "unit" & unitIndex> > <cfset tempName = ListGetAt(nameList, unitIndex)> > <cfset unitNameX = "unitName" & unitIndex> > <cfset tempNova = ListGetAt(novaList, unitIndex)> > <cfset companyX = "company" & unitIndex> > <cfset tempActive = ListGetAt(activeList, unitIndex)> > <cfset activeX = "active" & unitIndex> > <cfoutput>&#unitX#=#tempUnit#</cfoutput> > <cfoutput>&#unitNameX#=#URLEncodedFormat(tempName)#</cfoutput> > <cfoutput>&#companyX#=#tempNova#</cfoutput> > <cfoutput>&#activeX#=#tempActive#</cfoutput> > <cfoutput>#chr(13)#</cfoutput> > </cfloop> > <cfoutput>&unitCount=#flashtext.recordCount##chr(13)#</cfoutput> > <cfoutput>&eof=1</cfoutput> > ------------------------------------------------ > > The above template would return output like: > ------------------------------------------------ > &unit1=1&unitName1=NOVA%20%2D%20Joffre%20Personnel&company1=True&active1=Tru e > &unit2=11&unitName2=Coutts%20Electrical%20Ltd%2E&company2=False&active2=True > &unit3=3&unitName3=HATSCAN&company3=False&active3=True > &unit4=4&unitName4=Modern%20Plant%20Services&company4=False&active4=True > &unit5=10&unitName5=multimedia%20works&company5=False&active5=False > &unit6=12&unitName6=O%27Reilly%20Insulators%20Inc%2E&company6=False&ac > tive6=True > &unit7=2&unitName7=Quinn%20Contracting&company7=False&active7=True > &unitCount=7 > &eof=1 > > Then in Flash I'd check whether the variables have been loaded by > checking the value that the value of eof = 1: > > If (eof = 1) > Go to and Play ("Done") > Else > Go to and Play ("Check") > End If > > After the variables have been loaded, I use this action to convert > the results to variables: > > Loop While (index <= unitCount) > Set Variable: "tempUnitID" & index = Eval("unit" & index) > Set Variable: "tempUnit" & index = Eval("unitName" & index) > Set Variable: "tempCompany" & index = Eval("Company" & index) > Set Variable: "tempActive" & index = Eval("active" & index) > Set Variable: "index" = index + 1 > End Loop > Go to and Play ("Display") > > Now, depending on what you're doing in your display, the results > should display something like: > > http://mark.foxmicro.net/flashmenu/ > > This example posts a random siteID to the ColdFusion template. To see > the data that is used to build this menu try: > > http://mark.foxmicro.net/cf_flash/flashtest3.cfm?SiteID=1 or SiteID=11937 > > I hope this helps. > > Mark Zukiwsky > Edmonton, Canada > ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
