Steven S. Ross

If you aren’t aware, yes you can cache the results of stored procs in ColdFusion 8 using cachedwithin. However, be aware that ColdFusion only caches the first result set so If you are returning multiple result sets you are only going to get the first result set. So if you happen to be thinking ahead while you are coding and start out by setting the cachedwithin parameter you will never see multiple result sets.

To give credit where credit is due, my co-worker, Matt Hintze discovered this yesterday when we were trying to figure out why we weren’t getting multiple result sets back from a proc that we knew returned multiple sets every time it ran.

Hopefully this will be addressed by Adobe as caching multiple result sets would be the expected behavior inside a proc.