> <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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273328
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
