Got it... now I see where Mike set that variable in the display page near the top. I couldn't find that variable for the longest time!
Thanks, Adrian! Rick > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: Friday, September 12, 2008 11:42 AM > To: CF-Talk > Subject: RE: Problem with my attempt at CFC/OO usage... > > You'll need to assign the returned query to a variables: > > <cfset theQuery = yourCFC.GetAllAnnouncements()> > > Then: > > <cfloop query="theQuery"> > ... > </cfloop> > > Adrian > > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: 12 September 2008 16:32 > To: CF-Talk > Subject: Problem with my attempt at CFC/OO usage... > > > 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:312454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
