On Wed, May 6, 2009 at 4:32 PM, David Torres <[email protected]> wrote: > > I have been doing a lot of reading about stored procedures. I have worked w/ > SPs in MS SQL. Now I am using ColdFusion. > > Well, with my reading done I have been able to call a SP from a cffunction. I > have all my functions in a CFC file, and I would like to keep it that way. > Now, I need to return the cfprocresult from my SP within my function, which I > can do, but if I pass a OUT paremeter to my SP, how can I return my resultset > and my output variable from the function in order to use those values later?
you can return anything from within a cffunction via the <cfreturn> tag. create a struct in the function and populate the struct with your resultset and the output variable. cfreturn the struct. -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
