Hello list - I am sure it is from lack of sleep.. But i have this existing page working as is - multiple pages use it to output simple lists... However all the outputs are grouped.. may or may not be screwing me up.
In any event - I have tried adding a loop so I can add the values to an array list- but i consitently keep getting the intended array as grouped output instead of a comma seperated array... In this case I beleive code will explain it best - There are 2 output styles - 1 gives me an ordered type list - moduleFeature1= moduleFeature2 etc etc - These are necessary because this included page creates links that send variables to flash movies, receive from flash movies and most importantly jump CSS scrolls using div's instead of anchors -( because of netscrape and anchors unsupported in any clip ) Any event - The output that appears as : --------&ModuleFeature1=Registration, Preadmission, Census &ModuleFeatureLink1=/OutpatientProviders/OutpatientManagementSystems.cfm?ShowNameRef=Yes#section1 &ModuleFeature2=Billing / Receivables etc etc-------- is good. BUT I am trying get the information into an array because duplicating text fields and movie clips in flash is giving me a bit of problems. So if I split an array I can use the information better. I am not using any Flash MX Components because this absolutely needs to be a flash 5 file - additionally - components are way to heavy and I have this working very quickly. Just want to manage the information in flash better than having to constantly use for loops to set the module1, module2 type data. Code below- Hopefully I am somewhat coherent on this - thanks for any help jay miller p.s - http://64.234.202.15/ApplicationSystems/index.cfm?ProviderPage=Out_Related&ApplicationPage=2&CleanFlashURL=Yes is the variable output page - If you simply remove the CleanFlashURL=Yes - you will see a whole different world - which has the lists being pulled from this same file.. =========================code as it exists ============================= <cfparam name="ApplicationPage" default=""> <cfparam name="URL.ApplicationPage" default=""> <cfparam name="ProviderPage" default=""> <cfparam name="URL.ProviderPage" default=""> <cfparam name="ModulePage" default=""> <cfparam name="ShowList" default=""> <cfparam name="ShowAllDesc" default=""> <cfparam name="ProviderPath" default=""> <cfparam name="ProviderFullPath" default=""> <cfparam name="CleanFlashURL" default=""> <cfset ApplicationPage=URL.ApplicationPage> <cfif URL.ProviderPage IS NOT ""> <cfset ProviderPage=URL.ProviderPage> <cfset ShowList="Yes"> </cfif> <!-- global appllication, module and feature lookup/output START--> <cfquery name="GetModuleFeatures" datasource="#dsndata#" cachedwithin="#createTimeSpan(0,0,20,0)#"> SELECT mf.iModule, mf.iApplication, mf.sModuleFeature, mf.sFeatureIndent, mf.sFeatureSubHeading, mf.sFeatureSubHeadingSort, mf.iModuleID, mf.LTC_Related, mf.Reh_Related, mf.Inp_Related, mf.Out_Related, am.smodulename FROM ModuleFeatures mf, applicationmodules am WHERE mf.imodule = am.iapplicationmoduleID AND #ProviderPage# = 1 AND iApplication = #ApplicationPage# ORDER BY iApplication, iModule, sFeatureSubHeading </cfquery> <cfset div_tick = 0> <cfset count = 0> <cfoutput> <cfif CleanFlashURL EQ "Yes"> <cfelse> <ul class="FeaturesListSq#ProviderPage#"> </cfif> </cfoutput> <cfoutput query="getmodulefeatures" group="iModule"> <cfset div_tick = IncrementValue(div_tick)> <cfset count = IncrementValue(count)> <cfif CleanFlashURL EQ "Yes"> <!--- loop ModuleName and Link for flash usage - don't display ---> &ModuleFeature#Count#=#sModuleName# &ModuleFeatureLink#Count#=#ProviderFullPath#?ShowNameRef=Yes##section#count# <cfelse> <li><a href="#ProviderFullPath#?ShowNameRef=Yes&ProviderFullPath=#ProviderFullPath###section#count#"> #smodulename# </a></li> </cfif> </cfoutput> <!--- second attempt - still grouped but not looping through results as they should ---> <cfoutput> <cfif CleanFlashURL EQ "Yes"> <cfloop query="getmodulefeatures"> <cfset modulefeature_list=""> <cfset modulefeature_list=listappend(modulefeature_list,sModuleName,",")> &ModuleFeatures_list=#modulefeature_list#&status=1 </cfloop> </cfif> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
