I have a stored procedure in Oracle 9i that I am calling from a CF5 page. One of the things the SP does is it returns a variable that is essentially a number count. The SP executes without error and returns the expected value.
What I am running into is if I try to take that value returned and put it within a cfset along with some text and then output that, all that shows up is just the value from the SP and not the text. Here is some code from a test page as I word in the set/output at the bottom one will have the text and the other cuts off at the http://www.developer.be/paste/DspPaste.cfm?id=2863 I have also tried qualifying the Msg variable, such as <cfset Variables.Msg = .... Then I have also trying taking SPCount and setting it to a dummy variable then plugging that dummy variable into the Msg set but get the same results. I tried to do a cfdump on the spcount but just displayed its value. If I refer to SPCount as Variables.SPCount it runs the same. Here is the current version of the SP I have been working with, tried changing the out to NUMBER but worked the same. http://www.developer.be/paste/DspPaste.cfm?id=2864 -- Aaron Rouse http://www.happyhacker.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
