Short Version - I realize that is VERY long - but I jsut supplied alot of information - Temporary link online - http://64.234.202.15/dbindex.cfm
LookUp existing tables - need to be altered on cfquery end efficiently - 8: within 2 - 8 in Table ApplicationModules = Medical Records 2 in Table ApplicationTypes = Financial Applications. Simple question is - I am looking for an alternative to having to do this <!--- reassign numbers with names ---> <cfparam name="ThisApp" default=""> <cfif iApplication EQ 1> <cfset ThisApp ="Financial Systems"> <cfelseif iApplication EQ 2> <cfset ThisApp ="Management Systems"> <cfelseif iApplication EQ 3> <cfset ThisApp ="Clinical Applications"> </cfif> Jason Miller wrote: >In Coldusion - I run a simple query >to grab these features - ><cfquery name="GetModuleFeatures" datasource="#dsndata#"> >SELECT iModule, iApplication, sModuleFeature FROM ModuleFeatures >ORDER BY iModule, iApplication ></cfquery> > >And the output is equally as simple - ><cfoutput query="GetModuleFeatures" group="iModule"> >#iModule# : within #iApplication#<br> > ><cfoutput> #sModuleFeature#<br></cfoutput> ></cfoutput> >This outputs perfectly. And the statement above - #iModule# : within >#iApplication# was for a test. And it outputs correctly. So what it ends >up with is >8: within 2 - >8 in Table ApplicationModules = Medical Records >2 in Table ApplicationTypes = Financial Applications. > >So instead of >8: within 2 - I need it to say >Medical Records: within Financial Applications > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
