CFC Query not returning recordcount

[drmaves]

I wrote a CFC that performs a simple query. After the CFC runs the query I try
to check for the recordcount in the calling template and get the following
error:

Element RECORDCOUNT is undefined in CHECKTITLE.

Why can't I check the recordcount?

Here's the CFC function code:


<cffunction name="checkTitle"
displayname="Check Title"
hint="Check Title"
returntype="query"
output="false">
<cfargument name="titlename"
required="yes">
<cfset var CheckTitle="">
<cfquery name="CheckTitle" datasource="#application.dsn#">
SELECT *
FROM title
WHERE name = '#titlename#'
</cfquery>
<cfreturn CheckTitle>
</cffunction>

Here's the call:

<cfinvoke
component="components.title"
method="checkTitle"
titlename="#form.name#">
</cfinvoke>

Here's where I check the recordcount:

<cfif CheckTitle.recordcount EQ 0 and url.function EQ "A">

[The ScareCrow]

Your main problem is that you don't have a "returnVariable" in the cfinvoke

<cfinvoke component="components.title" method="checkTitle"
titlename="#form.name#" returnVariable="rtnQuery"></cfinvoke>

Then you use the returnVariable to access the query, so the call would be
<cfif rtnQuery.recordcount EQ 0 and url.function EQ "A">

I would also suggest you develop a naming convention. You have everthing
called "CheckTitle" and I would assume at some point CF will not know which
"CheckTitle" your talking about.

Ken

[drmaves]

Thanks, that did the trick!