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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273333
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
