Hi, all...

Well, I'm giving the CFC/OO coding another glance
and have been working through Mike Kear's great introductory tutorial,
C22 CFC Tutorial (http://afpwebworks.com).

I'm trying to re-write some of the tutorial to fit a test scenario.

To keep this short and to the point:  If I have this method:

<cffunction name        = "GetAllAnnouncements"
            access      = "public"
            output      = "false"
            returntype  = "query"
            hint        = "Returns a query of all announcements in the 
database">
                                                
     <cfset var Q_GetAllAnnouncements = 0 />
                
     <cfquery name = "Q_GetAllAnnouncements" datasource = "#variables.dsn#">
                        
          select     *
          from       announcements
          order by   title
                                
     </cfquery>
                        
     <cfreturn Q_GetAllAnnouncements />
                        
</cffunction>

How do I reference the data returned to the calling page?
It would seem to make sense that the value following "cfreturn"
would be what should be referenced..."Q_GetAllAnnouncements", but
that doesn't work...

I tried:

- <cfloop query="Q_GetAllAnnouncements">
- <cfloop query="announcements_DAO.GetAllAnnouncements">
- <cfloop query="announcements_DAO.GetAllAnnouncements()">

I can do a cfdump with:

var = "#announcements_DAO.GetAllAnnouncements()#"

Help!  Lost in the sauce...

Rick


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312437
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to