How could I cache the following stored procedure for a day?
<CFSTOREDPROC PROCEDURE="spCategories" DATASOURCE="HTCYP">
<CFPROCRESULT NAME="spCategories" RESULTSET="1">
</CFSTOREDPROC>
Would it work like this??
<CFQUERY NAME="qCategory" DATASOURCE="HTCYP"
CACHEDWITHIN="#CreateTimeSpan(0,1,0,0)#">
EXEC spCategories
</CFQUERY>
Thanks.
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
