After talking to someone off list found this to be a good work around: <cfsavecontent variable="Msg"><cfoutput>#Variables.SPCount#</cfoutput> this displays correctly</cfsavecontent> <cfoutput>Test = #Variables.Msg#</cfoutput>
On Fri, 4 Mar 2005 14:41:10 -0600, Aaron Rouse <[EMAIL PROTECTED]> wrote: > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197528 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
