>I'm trying to improve a page I've written. It's a calendar, and I'm >using a custom tag to display the calendar itself. On one view of the >calendar, there can be four calls to that calendar custom tag (one for >the current month, 3 for the next 3 months). Rather than call the >same stored procedure once per custom tag call, I'd rather call it >once total from the CFM template, and then make that result set >available to the custom tags. > >Is there a way to accomplish this, or do I just need to make multiple >calls to get the recordset? > >Thanks, > >Pete
You could try putting the query into the request scope as in <cfquery name ="request.variableName" etc>. The request scope is available to custom tags and child tags, as well as to all other pages associated with the calling page. From LiveDocs: -- Used to hold data that must be available for the duration of one HTTP request. The Request scope is available to all pages, including custom tags and nested custom tags, that are processed in response to the request. This scope is useful for nested (child/parent) tags. This scope can often be used in place of the Application scope, to avoid the need for locking variables. Several chapters discuss using the Request scope. -- http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/variab35.htm hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
