> 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>
Off hand, which platforms support this calling convention?
Jim
------------------------------------------------------------------------------
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.
