I very much doubt it has anything to do with the SP. Did you include everything in the links you provided. My first guess would be that there's something in your code that's not quite right.
Ade -----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: 04 March 2005 20:41 To: CF-Talk Subject: Outputing SP result w/Oracle 9i and CF5 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/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.0 - Release Date: 02/03/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197529 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
