saving a query to an application variable

[LongHorn]

I want to save the result of a query to an application variable so I don't have to run the query multiple times.

I'm using Fusebox methodology.
Where should I put my query to run for the first time?
Where do I set the application variable? In application.cfm?

Please help.

 

[Jawa]

I think you may want to look into stored procedures and query caching