yup.
<cfquery name="thisqry" dsn="#dsn#"
cacchedwithin="#createtimespan(1,0,0,0)#">
EXEC myStoredproc 'mystr'
</cfquery>
remember you can't do this if the SP returns multiple recordsets though...
> -----Original Message-----
> From: BT [mailto:[EMAIL PROTECTED]]
> Sent: 29 August 2001 15:22
> To: CF-Talk
> Subject: caching stored proc data
>
>
>
>
>
>
> Can you to a cache of a stored proc instead of a cfquery?
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
