Can't output query from CFC even though it's a query object
I'm trying to output a query from a CFC but I keep getting "Complex object types cannot be converted to simple values.".
Here's the code:
promoManager.cfc
<cfcomponent displayname="promoManager">
<cffunction name="init" returntype="promoManager" hint="Initializes the controller">
<cfargument name="dsn" type="string" required="yes">
<cfset variables.dsn = arguments.dsn>
<cfreturn this>
</cffunction>
<cffunction name="getPromotions" returntype="query">
<cfset var qGetPromotions = "">
<cfquery name="qGetPromotions" datasource="#variables.dsn#">
SELECT promoID, promoName, promoCode, promoDesc, promoFromDt, promoToDt, introDiscount, proDiscount, execDiscount, premDiscount
FROM promotions
ORDER BY promoName
</cfquery>
<cfreturn qGetPromotions>
</cffunction>
</cfcomponent>
test.cfm
<cfset promoManager = createObject("component","cfcs.promoManager").init(attributes.dsn)>
<cfoutput>#IsQuery(promoManager.getPromotions())#</cfoutput></p> <--- this outputs YES
<cfset getPromotions = promoManager.getPromotions()>
<p><cfdump var="#getPromotions#"></p> <--- this dumps a query object
<cfoutput query="#getPromotions#">here<br /></cfoutput> <--- THIS GENERATES AN ERROR!
TIA
