>- see footer for list info -< Can you share the code that shows the invocation of the CFC?
Charlie Arehart CTO, New Atlanta Communications, makers of BlueDragon (678) 256-5395 [EMAIL PROTECTED] www.newatlanta.com/bluedragon/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Baynes > Sent: Friday, January 27, 2006 2:34 AM > To: Coldfusion Development > Subject: Re: [CF-Dev] ColdFusion Forgetting Cched Queries > > >- see footer for list info -< > Charlie Thanks for the reply. > > Basically I have a function in a CFC which returns a query. > It is very basic something like:- > > <cffunction name="getLatestNews" access="public" output="false" > returntype="query"> > <cfset var qGetNews = ""> > <cfquery datasource="#variables.sDSN#" name="qGetNews" > cachedwithin="#createTimeSpan(0, 1, 0, 0)#"> > SELECT TOP 10 nNewsID AS nID, > sNewsTitle AS sTitle, sNewsDesc AS sDescription > FROM tbl_News > ORDER BY dPublishedDate DESC > </cfquery> > <cfreturn qGetNews> > </cffunction> > > Now this will work for ages fine, then out of the blue the > page that calls it will suddenly start erroring on every > request. The error will say that qGetNews is undefined. I can > see no coding reason why that should ever occur, and as I > mentioned before when this happens I set cached queries to 0 > to clear the cache in the administrator and then set it back > to its original number. > > Thanks for the heads up on <cfobjectcache action = "clear"> I > didn't know about that, but I still have the issue as I > cannot rely on the automatic caching of CF. > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
