I have not thought of that Charlie. I will try that. Last night I thought a little more, and may be I will not need the Output variable at all.
Thanks, David > 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:322270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
