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? Thanks, david ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:322264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

