No worries, mate! I'm glad you seem to have gotten your problem fixed. Chris
Scott Stewart wrote: > I needed to display the results. I could use CFDump all along. > > -----Original Message----- > From: Christopher Jordan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 5:56 PM > To: CF-Talk > Subject: Re: return variable error > > Scott, > > Did CFDump not work for you, or are you looking for a way to output the > data to screen for display in the app? I guess I'm confused by all this > talk of strings when what I thought you wanted to do was dump the > results of the query to the screen presumably just to see what got returned. > > Otherwise, why aren't you looping over your result set to output the > data to the screen? I must be missing something... > > Chris > > Scott Stewart wrote: >> Here's the function.. >> >> <cffunction access="public" name="getBody" output="true" returntype="any" > description="gets body text"> >> >> <cfif IsDefined("url.id")> >> <cfset page_id= #url.id#> >> <cfelse> >> <cfset page_id= 0> >> </cfif> >> <cfquery datasource="#request.dsn#" name="qGetBodyContent"> >> SELECT bodyText_content >> FROM tbl_bodyText >> WHERE FK_page_id = #page_id# >> </cfquery> >> >> <cfreturn qGetBodyContent> >> </cffunction> >> >> -----Original Message----- >> From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, March 21, 2007 5:04 PM >> To: CF-Talk >> Subject: Re: return variable error >> >> You will need to pass back a string of the data no doubt. Post your CFC >> code. >> >> >> >> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, >> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, >> Registered in England, Number 678540. It contains information which is >> confidential and may also be privileged. It is for the exclusive use of > the >> intended recipient(s). If you are not the intended recipient(s) please > note >> that any form of distribution, copying or use of this communication or the >> information in it is strictly prohibited and may be unlawful. If you have >> received this communication in error please return it to the sender or > call >> our switchboard on +44 (0) 20 89107910. The opinions expressed within > this >> communication are not necessarily those expressed by Reed Exhibitions." >> Visit our website at http://www.reedexpo.com >> >> -----Original Message----- >> From: Scott Stewart >> To: CF-Talk >> Sent: Wed Mar 21 20:59:41 2007 >> Subject: return variable error >> >> Hey all, >> >> >> >> I've got a component that runs a query. The query returns a bunch of HTML > in >> a MS Access memo field. >> >> When I invoke the query I set a return variable called bodyStruct. I can >> dump this variable and see the contents >> >> >> >> <cfset BodyObj=CreateObject("component","webControl")> >> >> <cfinvoke component="#BodyObj#" method="getBody" >> returnvariable="bodyStruct"> >> >> >> >> >> >> When I try to use it in a cfoutput I get the following error >> >> >> >> " >> >> >> >> Complex object types cannot be converted to simple values. >> >> >> >> The expression has requested a variable or an intermediate expression > result >> as a simple value, however, the result cannot be converted to a simple >> value. Simple values are strings, numbers, boolean values, and date/time >> values. Queries, arrays, and COM objects are examples of complex values. >> >> The most likely cause of the error is that you are trying to use a complex >> value as a simple one. For example, you might be trying to use a query >> variable in a <CFIF> tag. This was possible in ColdFusion 2.0 but creates > an >> error in later versions. >> >> " >> >> >> >> Any ideas n how to output this sucker? >> >> >> >> Thanks >> >> >> >> sas >> >> >> >> >> >> >> >> >> >> Scott Stewart >> ColdFusion Developer >> >> HYPERLINK >> > "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=7241+Jillspring+Ct&csz=Sprin >> gfield%2C+VA.+22152&country=us" \n7241 Jillspring Ct >> Springfield, VA. 22152 >> >> >> HYPERLINK "mailto:[EMAIL PROTECTED]" > [EMAIL PROTECTED] >> HYPERLINK "http://www.sstwebworks.com"; \nhttp://www.sstwebworks.com >> >> >> tel: >> mobile: >> >> HYPERLINK >> > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-912-3076&Email=s >> [EMAIL PROTECTED]" \n703-912-3076 >> HYPERLINK >> > "http://www.plaxo.com/click_to_call?src=jj_signature&To=703-220-2835&Email=s >> [EMAIL PROTECTED]" \n703-220-2835 >> >> >> >> >> >> HYPERLINK >> > "https://www.plaxo.com/add_me?u=25770055805&src=client_sig_212_1_card_join&i >> nvite=1" \nAlways have my latest info >> >> HYPERLINK "http://www.plaxo.com/signature?src=client_sig_212_1_card_sig"; >> \nWant a signature like this? >> >> >> >> > -- http://www.cjordan.us ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
