One nice trick, Jeff, is if the sproc only returns a single recordset
(which, if you want to cache the result, many sprocs do), use cfquery and
run the "execute procedure" syntax in SQL. Then you can use the cachedwithin
attrib. But what the heck, just scope the sucker to application.
NAT
> -----Original Message-----
> From: Marsh, Jeffrey B [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 18, 2000 9:35 AM
> To: Fusebox
> Subject: RE: query caching (was dot notation)
>
>
> If you're like me (I know I am), you use stored procedures a
> lot to retrieve
> recordsets. The query caching in CF is only useful (? possible) with
> <cfquery>. Scoping recordsts returned from SPs to the
> application scope or
> session scope is an effective way to "cache" queries.
>
> ---
> Jeffrey B. Marsh
> professionals built the Titanic; amateurs built the Ark
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
