Is URL.id correct? Are you sure your hitting the right DB?
Without you asking CF to cache anything it won't. -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:39 To: cf-talk Subject: Re: Clearing out the query cache It's a plain ol' vanilla query <cfquery name="get_study" datasource="#request.dsn#"> select cycle_id, cycle.cycle_month, cycle.cycle_year, week_id, week.start_date, week.fiscal_year, study.id, study.pre_pretransplant, study.pre_pediatric_clinic, study.notes, study.pre_ahec, study.pre_univ, study.pre_absent, study.checked_in, study.contract_number, study.last_updated, person.fname, person.mname, person.lname, person.full_time, person.pid, person.physician_number, person.dept_no, person.study_group_id, person.dept from cycle left join week on cycle.id = week.cycle_id left join study on week.id = study.week_id left join person on study.person_id = person.id where (study.id = '#url.id#') </cfquery> If I run this in SQL server Enterprise Manager I get a fiscal year = 2009 If it's run in a CF Template fiscal year comes back as null/1905 Dave Watts wrote: >> unfortunately their not, it's the server's query cache that has them, >> is it possible to force them to not cache in the first place (without >> setting the query cache setting in the CF server to 0) >> > > Are you saying they're cached within the Server scope, and you > reference them as Server.yourqueryname? > > If so, you can manage them just like you would any other variable. You > can delete them using StructDelete, or overwrite them. > > The query cache setting in the CF Administrator affects queries cached > with CACHEDWITHIN/CACHEDAFTER. > > CF doesn't cache queries automatically. You must either use > CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application > or Server variables. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
