Skip to main content
J
jasonlevine
Participant
February 4, 2009
Question

cfstoredprocedure bug with multiple result sets and cachedwithin

  • February 4, 2009
  • 1 reply
  • 825 views
I've noticed either a bug or a "feature" in CF 8's cfstoredproc tag wherein using the cachedwithin parameter on the cfstoredproc tag and specifying multiple result sets causes only one of the result sets to be returned. Is this intentional? If not, is there any known workaround?

Otherwise, it's impossible to cache the results of a stored procedure that returns multiple result sets... and this makes things tough.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
February 4, 2009
jasonlevine wrote:
> I've noticed either a bug or a "feature" in CF 8's cfstoredproc tag wherein
> using the cachedwithin parameter on the cfstoredproc tag and specifying
> multiple result sets causes only one of the result sets to be returned.
> Is this intentional? If not, is there any known workaround?

yeah it's a known issue (though most folks don't even know you can cache an sp
resultset, the docs only mention this in a backhanded way, it's not in the main
docs for cfstoredproc).

you might want to do your own caching w/app or session vars anyway. cf's number
of cached queries probably isn't the most intelligent way of handling this.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices