involving views, and many tables) and always use cfstoredproc over calling
the procedures using cfquery. The downside is that there is no direct way to
cache the result set(s). So... Yesterday I started working on a CFC to load
a result set into either: session|application|server scope. The CFC has a
few methods: refresh(), remove(), init(), and cacheIt(). Anyways, does this
seem like a logical and organized approach to quasi-caching result sets from
stored procs? I know I could just set the result set into the scope of
preference in the cfprocresult tag, but I thought the above was more
versatile and useful.
Am I missing something major here? Does anyone else do it a different way?
Michael T. Tangorre
--------------------------------------------
Abacus Technology Corporation
Senior ColdFusion Developer
Advanced Certified ColdFusion MX Developer
8601 Georgia Avenue, Suite 400
Silver Spring, MD 20910
o. 301.495.4223
f. 301.562.9891
--------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
