That did it, thanks all
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 6:19 PM
To: CF-Talk
Subject: RE: return variable error
> <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>
That returns a recordset (qGetBodyContent). If all you want is the string,
return qGetBodyContent.bodyText_content. And, you might want to set your
RETURNTYPE attribute to "query" or "string", whichever you actually return.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
This email has been processed by SmoothZap - www.smoothwall.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273329
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
