> As far as I can tell, there are no caching attributes for
> CFSTOREDPROC the way there are for CFQUERY. Has anyone
> developed a generic tag to implement this? It should
> theoretically be possible to mimic CFSTOREDPROC and keep
> all the relevant stuff in server variables, but I don't
> think it's trivial, and I don't want to do it if someone
> else has.
It's an unfortunate omission that CFSTOREDPROC doesn't support the query
caching introduced in CF 4. However, if you're using a platform that
supports the ODBC call syntax for executing stored procedures through the
CFQUERY tag, you can call your stored procedure and have it cached:
<cfquery name="foo" datasource="bar"
cachedwithin="#CreateTimeSpan(1,0,0,0)#">
{ call mysp(#mynumericparam#, '#mystringparam#') }
</cfquery>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
