RE: Is an empty query object still a "good" query object?

[Trevor Holm-Laursen]

I think I got cut off

I don't think I've seen that.  I can quite happily check if a query
recordcount is 0 or not.

<cfcomponent>

            <cffunction name="myFunction" access="public"
returntype="query">

                  <cfset myResult="foo">

                    <!--- Will return no records --->

                        <cfquery name="qryTest"
datasource="#application.qryDSN#">

                                    Select *

                                    From tblArticle

                                    Where Homepage=2

                        </cfquery>

                        <cfreturn qryTest>

            </cffunction>

</cfcomponent>

Junk.cfm

<cfobject component="test" name="objtest">

<cfinvoke component="#objtest#" method="myFunction"
returnvariable="qryarticle">

<cfif qryArticle.recordcount EQ 0>

<cfdump var="#objtest#">

</cfif>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---