Not directly, because cf can't tell what the resulting query string looks
like after the proc executes.
Of course you can use your own logic to cache it
<cfset CacheID = 0001> <!--- A unique name of the query ---->
<cfif (useCache) >
<cfif IsInCache(CacheID ) >
return the query from the cache
<cfelse>
<cfstoredproc ....
<cfset ArrayPrepand(Application.Cache,query) = />
</cfif>
</cfif>
or you can do a QoQ and cache that.
SELECT * FROM MYquery
Justin
-----Original Message-----
From: Allan Cliff [mailto:[EMAIL PROTECTED]
Sent: 01 December 2003 11:36
To: CF - List
Subject: [ cf-dev ] Stored Procedures
Can you Cache a Stored Procedure? If so, how?
The same as CFQUERY with CACHEDWITHIN
Thanks
Allan
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
