No reason at all. Depending on your ColdFusion version: 1) You may want to investigate the use of ColdFusions built in query cacheing as well 2) Remember to lock all access to application scope variables.
Cheers >From: "Bogesdorfer, Dan" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Storing Queries in Application Scope >Date: Fri, 12 Jul 2002 10:20:58 -0400 > >Looking at macromedia tech tip at >http://www.macromedia.com/v1/handlers/index.cfm?ID=1582&Method=Full > >Why can I not just reference my queries at application.[queryName].[value] >throughout my application? > >Example: >I'm building 3 lists: Schools, Departments and Divisions. I build them in >the application.cfm as >1) application.schoolQuery >2) application.deptQuery >3) application.divisionQuery > >In my output page (Register.cfm) I could display them in a drop down list >as >such: ><select name="school"> > <cfloop query = "application.shoolQuery"> > <cfoutput> > > <option >value="#application.schoolQuery.schoolId........ > >Why do I need to go the route of the tech tip mentioned above at MM site? >I >haven't tested this fully as of yet because I'm building my lists in the >Register.cfm page each time its visited. > >Thanks... > >Daniel Bogesdorfer >Senior Programmer / Analyst >Office Of Research Health Sciences >University of Pittsburgh >412.648.2366 > > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
