Closing open cursors is definitely the province of SQlL not CF. But that's easy to fix, right? simply close/deallocate the cursor in the proc.
On Fri, Jul 16, 2010 at 9:51 AM, Shannon Rhodes <[email protected]>wrote: > > Not sure if I'm understanding the question, but any cursors in your stored > procedure would be a return type, i.e. you wouldn't be looping over it > within the proc (unless it was looped/closed for related business logic). > By the time you call the proc from CF, CF is just saving the result set for > you, and then you have to do something else to loop over the result set. > cfstoredprod doesn't have to close a cursor because it doesn't open one or > loop over one. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
