yes but your resultset will now be qcategory instead of spCategories ----- Original Message ----- From: "Bosky, Dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 9:52 AM Subject: Is possible to cache a stored procedure?
> 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
