Outputting a CFC Component

[murpg]

Can someone please help me with this simple request. I get an error message
when I try and output the results of a simple CFC Component. Here is the error
message:

Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently "GetHomePageInfoRet", is
invalid.

Here is the component and the cfinvoke.




<cfcomponent displayname="Home Page Content" hint="This manages content">
<cffunction name="GetHomePageInfo" output="yes" returntype="query"
displayname="Get Home Page Content" hint="Function to get the content for the
PS Hospitality Home Page">
<cfquery name="gethome_info"
datasource="psfu"
dbtype="ODBC">SELECT *
FROM home
</cfquery>
<cfreturn gethome_info>
</cffunction>
</cfcomponent>

<p class="homeheader"><cfinvoke
component="psaims.PScontent"
method="GetHomePageInfo"
returnvariable="GetHomePageInfoRet"><cfoutput
query="GetHomePageInfoRet">#subtag#</cfoutput></p>

<p align="left"><cfoutput
query="GetHomePageInfoRet">#info#</cfoutput></cfinvoke></p>

[Darryl A. J. Staflund]

Try this:

<cfcomponent displayname="Home Page Content" hint="This manages content">
<cffunction name="GetHomePageInfo" output="yes" returntype="query">
<cfset var gethome_info = "" />
<cfquery name="gethome_info" datasource="psfu" dbtype="ODBC">
SELECT * FROM home
</cfquery>
<cfreturn gethome_info>
</cffunction>
</cfcomponent>

Darryl


"murpg" <webforumsuser@macromedia.com> wrote in message news:d85j56$es2$1@forums.macromedia.com...

> Can someone please help me with this simple request. I get an error message
> when I try and output the results of a simple CFC Component. Here is the error
> message:
>
> Attribute validation error for tag cfoutput.
> The value of the attribute query, which is currently "GetHomePageInfoRet", is
> invalid.
>
> Here is the component and the cfinvoke.
>
>
>
>
> <cfcomponent displayname="Home Page Content" hint="This manages content">
> <cffunction name="GetHomePageInfo" output="yes" returntype="query"
> displayname="Get Home Page Content" hint="Function to get the content for the
> PS Hospitality Home Page">
> <cfquery name="gethome_info"
> datasource="psfu"
> dbtype="ODBC">SELECT *
> FROM home
> </cfquery>
> <cfreturn gethome_info>
> </cffunction>
> </cfcomponent>
>
> <p class="homeheader"><cfinvoke
> component="psaims.PScontent"
> method="GetHomePageInfo"
> returnvariable="GetHomePageInfoRet"><cfoutput
> query="GetHomePageInfoRet">#subtag#</cfoutput></p>
>
> <p align="left"><cfoutput
> query="GetHomePageInfoRet">#info#</cfoutput></cfinvoke></p>
>

[murpg]

I tried your suggestion. Is there something wrong with the way I am trying to
output this? Here is my error message.

The value of the attribute query, which is currently "GetHomePageInfoRet", is
invalid.

[TA-Selene]

You don't need to hae output set to yes on this function. This should ONLY be
used if the function itself will be displaying data, and this is not
recommended. You are not outputting anything, you are returning a query.

I don't know if that is causing the problem, but I can't see anything else
wrong with this call.

[Adam Cameron]

> I don't know if that is causing the problem, but I can't see anything else

> wrong with this call.

Really?

What about the fact the <cfoutput> statements are *within* the <cfinvoke>
tags?

Probably best to have them AFTER the method has been called, not during,
eh? ;-)

NO:
<cfinvoke
component="psaims.PScontent"
method="GetHomePageInfo"
returnvariable="GetHomePageInfoRet"><cfoutput
query="GetHomePageInfoRet">#subtag#</cfoutput></p>

<p align="left"><cfoutput
query="GetHomePageInfoRet">#info#</cfoutput></cfinvoke>

YES:
<cfinvoke
component="psaims.PScontent"
method="GetHomePageInfo"
returnvariable="GetHomePageInfoRet">

<cfoutput
query="GetHomePageInfoRet">#subtag#</cfoutput></p>

<p align="left"><cfoutput
query="GetHomePageInfoRet">#info#</cfoutput>


Note: You only need a closing </cfinvoke> tag if you're using
<cfinvokeargument> tags.

--

Adam

[TA-Selene]

I missed that you had the </cfinvoke> tag after your CFOUTPUT. That is indeed
what is causing the problem. The queries won't exist until after the invoke is
processed, which won't be finished until the closing tag is reached. The only
thing you should have nested within your CFINVOKE tags are tags that pass
information to/from the object.